Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Add $ to the data

Hi,

 

Wonder if someone can help me on this. 

 

Had a column of data here and trying to add $ to get a summarised report however it wouldn't allow me, whereas it worked on the same type of data but from different excel files.

 

 
 

Cheers

Jimmy

Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    According to your description, it works well here.

    I am so confused that it doesnot work well after changing its format, so please create a measure to have a try:

    Measure = SUM('Purchase Adj - No Tax Code'[No Tax Code])

    Then, change this measure format to this:

    Hope it helps.

     

    If you still have questions, please for free to let me know.

     

    Best Regards,

    Giotto Zhi

     

     

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

       

      I have changed it to currency format somehow it still does not work.

       

      • v-gizhi-msft's avatar
        v-gizhi-msft
        Community Support
        6 years ago

        Hi,

         

        According to your description, it works well here.

        I am so confused that it doesnot work well after changing its format, so please create a measure to have a try:

        Measure = SUM('Purchase Adj - No Tax Code'[No Tax Code])

        Then, change this measure format to this:

        Hope it helps.

         

        If you still have questions, please for free to let me know.

         

        Best Regards,

        Giotto Zhi