formatting a measure with a text at the end

[amalrio]

Hi Gursu, 

I have a measure and I want to add the "M" at the end of it. at the moment output is like 12.0 what what I want to show is

12.0M. 

Below is my measure, can any expert modify it to what I want, 

any helap is appriciated.

===============

Measure  = 

VAR Total = CALCULATE ( SUM ( 'FACT-Data'[NUMARIC] ), 'DIM-Matrics'[MATRIX_ID] = 31 )

VAR Result = IF ( Total = 0, BLANK (), Total ) + 0

RETURN

Result

==============

[Anonymous]

Hi @amalrio 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[Anonymous · Accepted solution]

Hi @amalrio 

In addition to  amitchandak 's reply, if you add "M" directly, the result will show you 12M not 12.0M. You may try Format function to convert 12 to 12.0 M.

Measure  = 

VAR Total = CALCULATE ( SUM ( 'FACT-Data'[NUMARIC] ), 'DIM-Matrics'[MATRIX_ID] = 31 )
VAR Result = IF ( Total = 0, BLANK (), Total ) + 0
RETURN
FORMAT(Result,"0.0M")

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@amalrio , You can do like & "M" but till become text after that

Measure =
VAR Total = CALCULATE ( SUM ( 'FACT-Data'[NUMARIC] ), 'DIM-Matrics'[MATRIX_ID] = 31 )
VAR Result = IF ( Total = 0, BLANK (), Total ) + 0
RETURN
Result & "M"

refer formatting under model view, if that can help

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.