topic Re: European number format in DAX Commands and Tips

European number format

Raph — Tue, 21 Mar 2023 21:16:08 GMT

Hello

I have this measure in a card :

Text invoice = "Please send your invoice of " & FORMAT([Total royalties], "###,###.00") & " € to royalties@mycompany.com".

This measure displays the following format : 1,465.78 €... but I am looking for getting the european format : 1.465,78 €

I have already the regional parameters settled on French (global and active file).

Any idea?

Thank you!

Raphaël

Re: European number format

puneetvijwani — Tue, 21 Mar 2023 21:37:55 GMT

Raph
Try below workaround measure and let me know if that works

Text invoice =

VAR USFormatted = FORMAT([Total royalties], "###,###.00")

VAR Step1 = SUBSTITUTE(USFormatted, ",", "|") -- Replace ',' with a temporary character ('|')

VAR Step2 = SUBSTITUTE(Step1, ".", ",") -- Replace '.' with ','

VAR EuroFormatted = SUBSTITUTE(Step2, "|", ".") -- Replace the temporary character ('|') with '.'

RETURN

"Please send your invoice of " & EuroFormatted & " € to royalties@mycompany.com"

-------------------------------------------------------------------------------------------------------------------------------

Good day, amigo! Have I provided the solution? If so, please let me know by adding the lovely, sweet "solution" tag to my post. And hey, if you're feeling very kind, give me a Kudos; after all, who doesn't enjoy a little digital gratitude?

-------------------------------------------------------------------------------------------------------------------------------

Linkedn :-https://www.linkedin.com/in/puneet-v-376470135/
Youtube :-https://www.youtube.com/@datatrends101

Re: European number format

Raph — Wed, 22 Mar 2023 06:41:31 GMT

Thank you very much, puneetvijwani !

It's smart and it works.

Raphaël