Forum Discussion
Concatenate Measure and Text
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 Numb...
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.
NathanielYou can use
format ( <your formaul>,"###.##") & "<Currency symbol>"
- Reporting Period = IF(ISFILTERED(DATES[Reporting Period]),CONCATENATE("Reporting Period: ",SELECTEDVALUE(DATES[Reporting Period])))
You will need to define the formatting for both cases using IF clause, something like this:
CalculatedMeasure = IF(SELECTEDVALUE(Table1[FilterField]) == "Gaia", FORMAT(SUM(ARS211C[MONTANT FACTURABLE]), "Currency"), FORMAT(SUM(ARS211C[MONTANT FACTURABLE])), "General Number"))More on formats:
https://docs.microsoft.com/en-us/dax/pre-defined-numeric-formats-for-the-format-function
amitchandak
Super User
Super UserYou can use
format ( <your formaul>,"###.##") & "<Currency symbol>"
Reporting Period = IF(ISFILTERED(DATES[Reporting Period]),
CONCATENATE("Reporting Period: ",SELECTEDVALUE(DATES[Reporting Period])))