If then else

[Stuznet1]

Hi,

In the edit queries, how to write a code to tell if the [Attribute] = Prev then get the Value that is not 0?

[MohammadLoran25]

Hi @Stuznet1 

Can you provide more info pls? and is it possible that your value column includes several non-zero numbers ? Then what would be your expected result in this case?

And Is it okay if we do it in DAX (Calculated Column)?

Regards,

Loran

[Stuznet1]

Hi @MohammadLoran25 ,

Basically, I want non zero in the custom column but it must be in the Prev row