Share via

MDX Calculation

Anonymous
2021-06-17T10:02:44.717+00:00

I need to create calculation in SSAS Multidimensional using MDX. The calculation is to display last 5 years based on single selected year in Power BI Report. I have done this calculation in DAX Power BI.

The problem, I have to create power BI with Multidimensional Analysis Service. So, the calculation should using MDX Calculation. I'm stuck find the calculation using MDX. Any idea for this calculation using MDX?

Below I shared the formula DAX and visualization I expected. Thanks for helping. Much appreciate.

Dax:Last 5 Years = CALCULATE(SUM(Dummy[Value]),FILTER(Dummy,Dummy[Year]<=SELECTEDVALUE(Calender_1[Year])&&Dummy[Year]>=SELECTEDVALUE(Calender_1[Year])-4))

Community Center | Not monitored
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Leon Laude 86,201 Reputation points
    2021-06-17T10:29:10.477+00:00

    Hi @Anonymous ,

    Please note that Power BI is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products.

    You may ask the experts in the dedicated Power BI forum over here:
    https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

    ----------

    If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!

    Best regards,
    Leon

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.