Forum Discussion

Ania26's avatar
Ania26
Helper IV
1 year ago
Solved

Format Measure

Hello I have measure 

QTY = '2_Event_MAP'[Country]&" ("&'2_Event_MAP'[Sample QTY]&" )" and it looks like this  Australia (170000). How to make this number inside with thousend separator?
  • Hi Ania26 

    QTY = '2_Event_MAP'[Country]&" ("&Format('2_Event_MAP'[Sample QTY], "#,##0")&" )" 

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

3 Replies

  • Hi Ania26 

    QTY = '2_Event_MAP'[Country]&" ("&Format('2_Event_MAP'[Sample QTY], "#,##0")&" )" 

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