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 ,

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,