Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

0

DAX Formula bug

Hi, the following DAX formula in Card visualization has problem with CAD currency. Or let say with "C" and "D" character.

koorosh_0-1634756201032.pngkoorosh_1-1634756282243.pngkoorosh_2-1634756323025.pngkoorosh_3-1634756377798.png

koorosh_5-1634756509036.png

 

Status: Delivered
Comments
v-robertq-msft
Community Support

Hi,

According to your sample pictures, I can’t really understand where’s your existing issue, would you like to expalin it in detail?

 

Best Regards,

Community Support Team _Robert Qin

v-robertq-msft
Community Support
Status changed to: Investigating
 
koorosh
Post Partisan
koorosh
Post Partisan

Hi, when the currency is CAD the following formula can not display the C$ symbol!

"CAD","C$#,#"
 
koorosh
Post Partisan

Hi again, even the following formula does not make it correct!

"CAD",FORMAT(_invoice,"C$#,##0.##")

 

Best regards

v-robertq-msft
Community Support

Hi,

I have reported this issue internally, ICM: 268199699

 

I will update here once I get any information.

 

Best Regards,

Community Support Team _Robert Qin

koorosh
Post Partisan

Thanks.

v-robertq-msft
Community Support

Hi,

I’ve got this message from pg:

the first C in "C$#,##0.##" is a reserved letter in the string function AS uses (VarTokenizeFormatString ) indicating the input is of a calendar format, correct way of setting currency is escaping it like: "\C$#,##0.##", fixed pbix file attached.

 

And below is a download link of the attached pbix file from pg:

https://iceyzh-my.sharepoint.com/:u:/g/personal/robertqin_iceyzh_onmicrosoft_com/EU_etx107zlOqety0um... 

 

Best Regards,

Community Support Team _Robert Qin

v-robertq-msft
Community Support
Status changed to: Delivered
 
koorosh
Post Partisan

Thanks.