Forum Discussion

parry2k's avatar
parry2k
Icon for Super User rankSuper User
10 years ago

MTD questions

Hello all,   I have interesting question on MTD functionality and here is the question:   I have a date dimension as we know as best practice we should have date dimension and I do have one. I ha...
Need Help
  • bherring1979's avatar
    bherring1979
    Frequent Visitor
    10 years ago

    PREVIOUSMONTH will work, but I have to ask if that date format is supported? It must be, since CurrentMTD is working.

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      10 years ago

      Somehow my reply disappeared, seems like previous month is for full month not MTD. So in that case, do i have to have two measures, one for previousmonth and one for MTD

       

       

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        10 years ago

         

        As per the description in previousmonth function, it will return all dates for the month and in that case MTD will not work.

         

        Here is the what is says on this link https://support.office.com/en-US/article/PREVIOUSMONTH-Function-DAX-72fb8dda-6cd6-49e6-b9b4-8a5f632439c2

         

        This function returns all dates from the previous month, using the first date in the column used as input. For example, if the first date in the dates argument refers to June 10, 2009, this function returns all dates for the month of May, 2009.