Is this a DAX Error ?

[Anonymous]

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? 

 

[v-piga-msft · Accepted 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

[v-piga-msft · Accepted 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

[Anonymous]

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,

[v-piga-msft · Accepted solution]

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