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.
This is an error on Data tools but as Tabular is the companion by excellense with Power BI, i'll post this here as a DAX error:
1) Can't format a number to string, every number [at least my 5 tries] where converted to this string 0tri0g
2) What is this error?
Solved! Go to Solution.
Hi @Anonymous,
Please try this formula.
Column 2 = FORMAT('Table1'[Column1],"")
Then you could get the right output.
For reference, you could have a good look at how to use Format function in DAX.
If you still need help, for your scenario, it seems that you are working SSAS Tabular, you'd better to post your problem to SSAS Community to get more professional help.
Best Regards,
Cherry
Hi @Anonymous,
About the image you place, it's PowerQuery right? So i can't use it because my PBI reports are connected to SSAS,
Format(aaa, "string") fails and it's an error, right?
1. I used Dax foruma with FORMAT function in Power BI not in Power Query.
2. It seems that we could not use the parameter like "string" in Format function. You'd better have a good look at this document which introduces how to use the parameter in FORMAT function.
Best Regards,
Cherry
Hi @Anonymous,
Please try this formula.
Column 2 = FORMAT('Table1'[Column1],"")
Then you could get the right output.
For reference, you could have a good look at how to use Format function in DAX.
If you still need help, for your scenario, it seems that you are working SSAS Tabular, you'd better to post your problem to SSAS Community to get more professional help.
Best Regards,
Cherry
It works,
Format(aaa, "string") fails and it's an error, right?
About the image you place, it's PowerQuery right? So i can't use it because my PBI reports are connected to SSAS,
Hi @Anonymous,
About the image you place, it's PowerQuery right? So i can't use it because my PBI reports are connected to SSAS,
Format(aaa, "string") fails and it's an error, right?
1. I used Dax foruma with FORMAT function in Power BI not in Power Query.
2. It seems that we could not use the parameter like "string" in Format function. You'd better have a good look at this document which introduces how to use the parameter in FORMAT function.
Best Regards,
Cherry
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
96 | |
89 | |
73 | |
61 | |
58 |