Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

If then else

Hi, In the edit queries, how to write a code to tell if the [Attribute] = Prev then get the Value that is not 0?  
Need Help
Show and Tell
Tips and Tricks
MohammadLoran25's avatar
MohammadLoran25
Solution Sage
3 years ago

Hi Anonymous 

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi MohammadLoran25 ,

 

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