Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. I want build a new custom column with an IF THEN ELSE statement that states IF that column is blank, to use the values of another column. IF it is not blank, it keeps the current value.
Solved! Go to Solution.
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.
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.
If the blank values are showing as null, you can use this expression. If they don't, you can use = "" instead.
= if [columnwithvalue] = null then [othercolumn] else [columnwithvalue]
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |