Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Current MTD shows blank values

Hello, I have a problem with MTD column. I want on this column to show only April '22 sales and not the previous months. For example the sales for April '22 is 7379,42 so I want this number only to be shown on MTD column, of course I want the same for the other product types. Thank you.

Need Help

4 Replies

  • AilleryO's avatar
    AilleryO
    Memorable Member
    4 years ago

    Hi,

     

    I would suggest to use DATESINPERIOD instead of MTD to get only one value, the one from previous month with something like :

    Total Last Month = CALCULATE([Total Amount], //Calculate your measure...
    DATESINPERIOD(Sales[Date invoice],//In a period of time
    TODAY(),//starting from today
     -1,//and back one...
    MONTH)) //month...
     
    This should bring you only one value. Let us know
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I have values for MTD but I want only the value of the latest month on the MTD column and also not change the information of the other columns.

      • v-chenwuz-msft's avatar
        v-chenwuz-msft
        Community Support
        4 years ago

        Hi Anonymous ,

         

        If possible, please share your pbix file without sensitive data and expect result.

        Best Regards

        Community Support Team _ chenwu zhu

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago