Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a measure called Amount which is the amount for a fiscal period.
Dimension FiscalPeriod
I would like to have a calculated measure who would give me
Fiscal. Period. Amount. Cumulative
16-17. 1. 10000. 10000
16-17. 2. 6000. 16000
16-17. 3. 3500. 19500
How do I do this in mdx script?
Thanks
Solved! Go to Solution.
@jgagnon69,
What do you mean "old version of SQL " ? You can use DAX to calculate running total in Power BI Desktop as long as you have connect to the SQL Server data source in Power BI Desktop. There is a blog about calculating running total for your reference.
If you still want to use MDX, please take a look at the following blogs. And I would recommend you post the question in the SSAS forum to get dedicated support.
Running total in MDX
Various way to calculate running total from All Period to Currentmember
Regards,
Lydia
Have no idea in mdx but in DAX you could just create a Running total Quick Measure.
I can’t use Dax as our customer is on an old version of SQL Server
Thanks
@jgagnon69,
What do you mean "old version of SQL " ? You can use DAX to calculate running total in Power BI Desktop as long as you have connect to the SQL Server data source in Power BI Desktop. There is a blog about calculating running total for your reference.
If you still want to use MDX, please take a look at the following blogs. And I would recommend you post the question in the SSAS forum to get dedicated support.
Running total in MDX
Various way to calculate running total from All Period to Currentmember
Regards,
Lydia
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |