Forum Discussion

Kurt4597's avatar
Kurt4597
Helper I
3 years ago

Filtering Measure By Date

Hello All,   I have been stuck on this issue for a few hours and really can't seem to fix it. Any help would be greatly appreciated.  DateDim Table     Deals Table     I have a...
Need Help
rsbin's avatar
rsbin
Community Champion
3 years ago

Kurt4597 ,

Looks to me like you are comparing a MonthYear column to a YearMonth value (2022-04).

Try changing your [MonthYear] in your Measure to [YearMonth].

Regards,

  • Kurt4597's avatar
    Kurt4597
    Helper I
    3 years ago

    Apologies, that was just a mistake I made when pasting over from the sample file. The issue is still present

    • rsbin's avatar
      rsbin
      Community Champion
      3 years ago

      Kurt4597 ,

      Can you please post the Measure you have for "Previous Date"?

      Unfortunately, my network here won't allow me to access your link above.

      • Kurt4597's avatar
        Kurt4597
        Helper I
        3 years ago

        PreviousDate = date(if( Values(DateDim[Month]) = 1, Values(DateDim[Year]) -1, Values(DateDim[Year])), if(Values(DateDim[Month]) = 1,12, (Values(DateDim[Month])-1)), "01")