Forum Discussion

vksk0338's avatar
vksk0338
New Member
2 years ago
Solved

DAX Query to subtract current col from previous column

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.

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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