Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

comparison when two consecutive years are selected

  I have a power BI dashboard where I am getting data from Live Query so all the calculated measure coming from SSAS cubes. There are two measures which has the calculated data of current year and ...
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Can Anyone suggest me on MDX?

I have created MDX to calculate data for last year. Which is

([Product Volume],ParallelPeriod([Time].[Year Code Dynamic].[Year Code Dynamic],1,[Time].[Year Code Dynamic].CURRENTMEMBER))

 

Do I need change in that?

 

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous ,

In Power BI, it supports DAX currently.

If you want to get support of MDX, you should post your requirement in SSAS Forum to get the most professional help.

If you want to achieve your desired output in Power BI, you could import you data in Power BI and then create the dax formual as parry2k mentioned.

If you need help for dax, please share your data sample with table format so that I could have a test on it.

Best  Regards,

Cherry