Forum Discussion

Ania26's avatar
Ania26
Icon for Helper IV rankHelper IV
2 years 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?
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

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