How do I use MDX using an Invoice Age to correlate to 5 fixed Aging Buckets to then use as Dimesion slice on the balance?

Paul Mauriello 1 Reputation point
2021-07-15T20:30:24.723+00:00

How do I use MDX using an Invoice Age to correlate to 5 fixed Aging Buckets to then use as Dimesion slice on the balance?

This is as far as I got but i know its wrong. Instead of having an Balance column i want to split across the bucket?

115139-image.png

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,245 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,856 Reputation points
    2021-07-16T06:43:19.94+00:00

    Hi @Paul Mauriello ,

    Welcome to Microsoft Q&A!

    Please refer to below links:

    Assign bucket types dynamically with MDX and dynamic sets in Analysis Services
    How to create buckets on measures from 2 fact tables, i.e variance between actual and budget coming from separate fact tables

    Best regards,
    Carrin

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments