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.
Hello,
Could you please answer the following:
I was trying to create a calculation showing SUM(Montant Facturable) and the Currency, and the reason why I'm using this method not the default Number Formatting is that Gaia is a Number and Montant is Currency; so when I select Montant, I would like to see 2 decimals and Euro currency,
Thank you,
Solved! Go to Solution.
Hi @Anonymous ,
Not sure if I understand exactly what you are asking, however when you create a measure you will have control over the format by going to the Modeling tab and selecting the Format.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
You can use
format ( <your formaul>,"###.##") & "<Currency symbol>"
You will need to define the formatting for both cases using IF clause, something like this:
More on formats:
https://docs.microsoft.com/en-us/dax/pre-defined-numeric-formats-for-the-format-function
You can use
format ( <your formaul>,"###.##") & "<Currency symbol>"
You will need to define the formatting for both cases using IF clause, something like this:
More on formats:
https://docs.microsoft.com/en-us/dax/pre-defined-numeric-formats-for-the-format-function
Hi @Anonymous ,
Not sure if I understand exactly what you are asking, however when you create a measure you will have control over the format by going to the Modeling tab and selecting the Format.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |