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.
Hi!
I try to calculate a new column, where I want to subtract two columns from different tables if one of the columns is not blank. I used this DAX:
Solved! Go to Solution.
So in my understanding, you dont want to substact when that column has blank right.
In that case, you rewrite as folows:
if(not(blank(col1)), col1- col2, "Pass your else command")
Pass your else command when blank value appears.
Hope this solves the problem and kindly mark this as solution
So in my understanding, you dont want to substact when that column has blank right.
In that case, you rewrite as folows:
if(not(blank(col1)), col1- col2, "Pass your else command")
Pass your else command when blank value appears.
Hope this solves the problem and kindly mark this as solution
Seems to be correct. I was about to write the same logic.
@Marit Kindly mark as solution .
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |