MDX to DAX Conversion.

[Anonymous]

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:

[Anonymous]

I found this link useful:

https://sqlsrv4living.blogspot.com/2018/09/dax-previous-period-combined-measure.html

[v-diye-msft]

Hi @Anonymous 

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

[amitchandak]

@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]

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?