Forum Discussion

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

Ania26's avatar
Ania26
Icon for Helper IV rankHelper IV
1 year ago

Yes! thank you 🙂

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    1 year ago

    Happy to help 🙂