Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a measure in Decimal format and I want to replace blank values with "N/A". But getting below error. How to solve this?
Solved! Go to Solution.
Hello,
Try to make the second condition like this : format( ( [wos*7]),"#")
If I answered your question, please mark my post as solution, Appreciate your Kudos!
Proud to be a Super User! | |
Still getting same error. Cannot convert value 'N/A' of type text to type number.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
85 | |
65 | |
64 |