Forum Discussion

kristi_in_heels's avatar
kristi_in_heels
Icon for Helper II rankHelper II
2 years ago
Solved

Help with Relative Dates & Measure for 2 Months Time excluding next month

Hello,   I am trying to create a visual using cards, which will return 3 separate values for this month, next month, and the month after that.   Using relative dates works for this month and next...
Need Help
  • kristi_in_heels's avatar
    kristi_in_heels
    2 years ago

    I have managed to use your format to create a measure which is working for +2 Months, thank you for your help.

     

    CPS This Month +2 =
    var _min = eomonth(today(),0)+2
    var _max = eomonth(today(),2)
    return CALCULATE([CPS Monthly], FILTER('Calendar','Calendar'[Date] >=_min && 'Calendar'[Date] <= _max))
kristi_in_heels's avatar
kristi_in_heels
Icon for Helper II rankHelper II
2 years ago

I have managed to use your format to create a measure which is working for +2 Months, thank you for your help.

 

CPS This Month +2 =
var _min = eomonth(today(),0)+2
var _max = eomonth(today(),2)
return CALCULATE([CPS Monthly], FILTER('Calendar','Calendar'[Date] >=_min && 'Calendar'[Date] <= _max))