Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

IF THEN

Is there a way to replicate this formula in Power BI?

 

IF [Org Code] = 'HK' THEN ABS([Item Cost]*[Quantity]) END

 

 

Show and Tell
Tips and Tricks

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , In dax

     

    IF ([Org Code] = "K " , ABS([Item Cost]*[Quantity]) ,blank())

     

    or

     

    IF ([Org Code] = "K " , ABS([Item Cost])*abs([Quantity]) ,blank())

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Has your problem been solved? What column is from a different table, [Org Code], [Item Cost] or [Quantity]?

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.