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")

      • rsbin's avatar
        rsbin
        Community Champion
        3 years ago

        Kurt4597 ,

        I was able to download your file.  Took a quick look but am sorry that I haven't been able to decipher the issue.  I would like to suggest you re-post your question in a new thread.  This will give someone else an opportunity to try to resolve your issue.  Also fix the typo/error in your Average Cost formula. 

         

        I will give your file another look later today if I get the chance.

        Regards,