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 have the below formula that is calculating the last blank value and pulling it into this new table. My question is it easily possible to add another part of this formula to insert the phrase "Not submitted" if the formula is pulling a blank value.
Solved! Go to Solution.
Hi,
before your formula place If( your whole formula=blank(), "Not submitted", yourfromula)
or to make things cleaner use variable:
Completed=
var vCompleted= your formula
If( vCompleted=blank(), "Not submitted", vCompleted)
That worked! Thank you so much!
Please kudo and accept as a solution, thank you!
Hi,
before your formula place If( your whole formula=blank(), "Not submitted", yourfromula)
or to make things cleaner use variable:
Completed=
var vCompleted= your formula
If( vCompleted=blank(), "Not submitted", vCompleted)
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 |