Forum Discussion
Concatenate Measure and Text
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
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