DAX

[Hoai_Khang1205]

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

[Arul]

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

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

[v-easonf-msft]

Hi, @Hoai_Khang1205 

Not sure what you  want.

Can you explain what the formula means?

Best Regards,
Community Support Team _ Eason