Forum Discussion

bobceres's avatar
bobceres
Regular Visitor
4 years ago
Solved

IF THEN ELSE

I am familiar with IF THEN ELSE statements in excel, but not sure how it translates to DAX.  Essentially I have a column with several 6 digits numbers, but some of the values in that column are blank...
  • v-robertq-msft's avatar
    v-robertq-msft
    4 years ago

    Hi, bobceres 

    According to your description, I can roughly understand your requirement, I think you can create a calculated column like this to achieve your requirement:

    This is my test data:

    Expected ID =

IF(ISBLANK([ID1]),[ID2],[ID1])

     

    And you can get what you want, like this:

     

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

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

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, bobceres 

According to your description, I can roughly understand your requirement, I think you can create a calculated column like this to achieve your requirement:

This is my test data:

Expected ID =

IF(ISBLANK([ID1]),[ID2],[ID1])

 

And you can get what you want, like this:

 

You can download my test pbix file below

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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