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 trying to create a new column Days to review.
Days to Review = Posting close date - Actual Date.
Not sure how to perform this in DAX (I am new to Power BI) - I tried regular subtraction but it's giving me an error due to "N/A".
Is there a way I can exclude "N/A" from calculations and perform the subtraction/difference.
Posting Close Date | Actual Date Review Completed | Days to review |
11/5/2018 | 11/6/2018 |
|
N/A | 12/4/2018 |
|
2/11/2019 | 2/12/2019 |
|
11/5/2018 | 11/6/2018 |
|
N/A | 12/4/2018 |
|
N/A | 12/4/2018 |
|
5/7/2018 | 5/10/2018 |
|
Thank you for your help.
Solved! Go to Solution.
Hi @P_B
In Edit queries, change data type as "date",
the "N/A" field will become "error",
Replace error with null
File->Close&&Apply
You could create a column
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @P_B
In Edit queries, change data type as "date",
the "N/A" field will become "error",
Replace error with null
File->Close&&Apply
You could create a column
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @P_B ,
Try replacing N/As with Null or Blank or zero thru power query editor.
And then perform the subtraction logic..
Thanks,
Tejaswi
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 |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |