Forum Discussion

Hoai_Khang1205's avatar
Hoai_Khang1205
New Member
3 years ago

DAX

Hey, does any one know how to make a DAX calculation like this pic right here?. Thank you very much. Given dataset has code_id and places

 

Need Help
Tutorial Requests

3 Replies

  • Arul's avatar
    Arul
    Super User
    3 years ago

    Hoai_Khang1205 ,

    try this,

    Formula = IF(OR(inv quarter t-1 = 0,inv quarter t = 0),0,inv quarter t-inv quarter t-1)

    Thanks,

    • Hoai_Khang1205's avatar
      Hoai_Khang1205
      New Member
      3 years ago

      um. Im not sure if you understand my question correctly? but thanks btw. This is not the solution I need though.

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        3 years ago

        Hi, Hoai_Khang1205 

        Not sure what you  want.

        Can you explain what the formula means?

        Best Regards,
        Community Support Team _ Eason