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.
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
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 |
---|---|
104 | |
103 | |
87 | |
73 | |
66 |
User | Count |
---|---|
119 | |
111 | |
95 | |
79 | |
72 |