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 all,
Here is my code:
Solved! Go to Solution.
My bad, didn't realize the formatting used in your formula.
Try those suggestions without the Format function to replace the blanks with 0.
Or change your format from ("#,###" to "0,0") and see if that resolves.
More on formatting here:
https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-numeric-format-strings
Regards,
Tarun
Did I answer your question? Mark my post as a solution!
Try this: Add 0 to your [Total Valet] measure.
TotalValetSite = Format(FactLots[Total Valet] + 0,"#,###") & " total valets this week."
If that does not work, try the following:
TotalValetSite = Format(IF(FactLots[Total Valet] = BLANK(), 0 , FactLots[Total Valet]),"#,###") & " total valets this week."
Regards,
Tarun
Did I answer your question? Mark my post as a solution!
Thank you Tarunsingla, however, neither of those options worked 😞
My bad, didn't realize the formatting used in your formula.
Try those suggestions without the Format function to replace the blanks with 0.
Or change your format from ("#,###" to "0,0") and see if that resolves.
More on formatting here:
https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-numeric-format-strings
Regards,
Tarun
Did I answer your question? Mark my post as a solution!
Thank you again, have a nice day!
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |