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?

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?

Hi @PaulMauriello-5424, we have not received a reply from you, any update for this case?
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.
6 people are following this question.
File for a cloned Vertipaq data object conflicts with a master data object file
dimension security on a combination of dimensions
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
Getting error message as "Unable to find any Microsoft OLE DB providers on the machine."
How to schedule SQL profiler to auto start/stop to capture SSAS synchronization?