Working with time periods, I have what I want for the past, but how can I add in future? Looking for Next 90 days, etc
Current dax
Time Periods =
var _today =
MAX ( 'Date Refresh'[Date])
var _thisyear =
YEAR ( _today )
var _thismonth =
MONTH ( _today )
var _thisday =
DAY ( _today )
return
SELECTCOLUMNS(
UNION(
//Yesterday
ADDCOLUMNS(
GENERATE(
SELECTCOLUMNS( {"Yesterday"}, "Period", [Value] ),
GENERATESERIES(DATE(_thisyear, _thismonth, _thisday -1), _today -1)
),
"Axis Date", [Value]
),
//Last30Days
ADDCOLUMNS(
GENERATE(
SELECTCOLUMNS( {"Last 30 Days"}, "Period", [Value] ),
GENERATESERIES(DATE(_thisyear, _thismonth, _thisday -30), _today -1)
),
"Axis Date", [Value]
),
//Last60Days
ADDCOLUMNS(
GENERATE(
SELECTCOLUMNS( {"Last 60 Days"}, "Period", [Value] ),
GENERATESERIES(DATE(_thisyear, _thismonth, _thisday -60), _today -1)
),
"Axis Date", [Value]
),
//Last90Days
ADDCOLUMNS(
GENERATE(
SELECTCOLUMNS( {"Last 90 Days"}, "Period", [Value] ),
GENERATESERIES(DATE(_thisyear, _thismonth, _thisday -90), _today -1)
),
"Axis Date", [Value]
),
//LastMonth
ADDCOLUMNS(
GENERATE(
SELECTCOLUMNS( {"Last Month"}, "Period", [Value] ),
GENERATESERIES(DATE (_thisyear, _thismonth -1, 1), EOMONTH( _today,-1) )
),
"Axis Date", [Value]
)
),
"Date", [Value],
"Period", [Period],
"Axis Date", [Axis Date]
)
