Forum Discussion

Jun_Wang's avatar
Jun_Wang
Icon for Advocate I rankAdvocate I
7 years ago
Solved

IF statement in DAX

Could you please help write one DAX formular (calculated column)?   The desired output is like this: If Column A is blank, the newly addedColumn = the value in the Column B, otherwise return the v...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Jun_Wang 

    You can use expression below.

    Column = 
IF( 
    YourTable[Column A] = BLANK(), 
    YourTable[Column B], 
    YourTable[Column A]  
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski



Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Jun_Wang 

You can use expression below.

Column = 
IF( 
    YourTable[Column A] = BLANK(), 
    YourTable[Column B], 
    YourTable[Column A]  
)

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski



Jun_Wang's avatar
Jun_Wang
Icon for Advocate I rankAdvocate I
7 years ago

Thank you :)