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

2 Replies

  • 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