Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

MDX to DAX Conversion.

Hi All,

 

Please can you help in converting this MDX Calculated Measure to DAX Calculated Measure:

 

MDX:

(
ParallelPeriod(
[Ledger Period].[Fiscal Hierarchy].currentmember.level,1)
,[Measures].[Transaction Amount])

 

 

This [Ledger Period].[Fiscal Hierarchy] hierarchy has 5 levels:

 

MDX to DAX.PNG

4 REPLIES 4
Anonymous
Not applicable
v-diye-msft
Community Support
Community Support

Hi @Anonymous 

 

I don't know much about the MDX language. Maybe you can refer to this article: Converting MDX to DAX.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
amitchandak
Super User
Super User

@Anonymous ,You have parallelperiod in DAX too

https://docs.microsoft.com/en-us/dax/parallelperiod-function-dax

Can you let us know what you want to achieve, we can give better formula

Anonymous
Not applicable

I think, I have provided enough infomation.

 

So From Hierarchy If we Select Year then Measure should Return Prior Year data

Same Way If I select month from Hierarchy then Measure should Retun Prior Month Data. 

 

Same hierarchy have created in Tabular. 

 

Can Parallelperiod be used for Hierrarchy? 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.