MDX to DAX Conversion.

Question

Hi All,&nbsp;Please can you help in converting this MDX Calculated Measure to DAX Calculated Measure:&nbsp;MDX:(ParallelPeriod([Ledger Period].[Fiscal Hierarchy].currentmember.level,1),[Measures].[Transaction Amount])&nbsp;&nbsp;This [Ledger Period].[Fiscal Hierarchy] hierarchy has 5 levels:&nbsp;

amitchandak · Answer

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 · Answer

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?

v-diye-msft · Answer

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

anonymous · Answer

I found this link useful:&nbsp;https://sqlsrv4living.blogspot.com/2018/09/dax-previous-period-combined-measure.html

Forum Discussion

MDX to DAX Conversion.

4 Replies

Related content

MDX to DAX

LAG Conversion from MDX to DAX

Conversion of Excel formulas to DAX within Power BI.

DAX vs MDX

FX Conversion Logic