DAX Query to subtract current col from previous column

[vksk0338]

I have a calculated field in tableau :ROUND(SUM([ECL_Prov_Final (in Cr)]) - LOOKUP(ZN(SUM([ECL_Prov_Final (in Cr)])), -1),2)
Please help me to write a DAX query in PowerBI.

[v-shex-msft · Accepted solution]

HI @vksk0338,

In power bi data model tables, current it does not include row and column index. Any fields that stored regular values to be use as the index for these calculations? Can you please share some more detail?

How to Get Your Question Answered Quickly  

BTW, you an also try to use the following measure formula if helps:

formula =
VAR _index =
    MAX ( Table1[Index] )
RETURN
    ROUND (
        SUM ( Table1[ECL_Prov_Final (in Cr)] )
            - LOOKUPVALUE ( Table1[ECL_Prov_Final (in Cr)], Table1[Index], _index - 1 ),
        2
    )

Regards,

Xiaoxin Sheng