how to add thousands separator to values based on switch true measure?

[oakfootballclub]

Hi experts, I created a multiple hierarchy column header in matrix, first I created a dimension table:

and then I created the measure to get revelent metrics:

I created the matrix by put the year_name, metric_name in the column and keep the hierarchy,

since there are percentage and decimals, how can I transform the decimals to have thousands separator ?

[SamWiseOwl · Accepted solution]

Good morning @oakfootballclub ,

Your DAX is looking great, to apply thousand seperators add them in to your FORMAT function.
FORMAT([cal_amount_FYTD_PreviousM], "0,0.00").

Also just checking you know there is the custom option for formatting measures?
Under format choose Dynamic:

This lets you have the formatting and the measure seperate:

Let me know if it works!
All the best

Sam