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...
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])))
- tarunsingla
Solution Sage
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
