Forum Discussion

andyor's avatar
andyor
Icon for Resolver I rankResolver I
4 years ago
Solved

DAX Date Statement not working

Would anybody know why my _last12months and _last24months variables aren't working? They basically filter for nothing   I've literally tried every possible combination possible of trying to do this...
Need Help
  • andyor's avatar
    andyor
    4 years ago

    Solution

     

    VAR _last12months = EDATE(TODAY(),-12)
    VAR _last24months = EDATE(TODAY(),-24)
andyor's avatar
andyor
Icon for Resolver I rankResolver I
4 years ago

Solution

 

VAR _last12months = EDATE(TODAY(),-12)
VAR _last24months = EDATE(TODAY(),-24)