Dax - Period To Date This Week Vs. Last Week

zfemmer — Mon, 19 Oct 2020 23:00:25 GMT

I am trying to have a line graph that displays last week's revenue and this week's revenue period to date.

I have figured out this week with this:

VAR _PeriodToDate = CALCULATE( SUM(RevenueChannel[BookedRevenue]), 'Date'[Date] <= _MaxDate, FILTER(ALL('Date'), 'Date'[Date] < TODAY() && 'Date'[Date] >= TODAY() - 7 ) )

But cannot seem to figure out how to do the last week. I know I can easily just do this:

VAR _PeriodToDateTest = CALCULATE( SUM(RevenueChannel[BookedRevenue]), 'Date'[Date] <= _MaxDate, FILTER(ALL('Date'), 'Date'[Date] < TODAY() - 7 && 'Date'[Date] >= TODAY() - 14 ) )

But then they do not line up on the line graph:

Does anyone know how I would accomplish this?

Re: Dax - Period To Date This Week Vs. Last Week

zfemmer — Mon, 19 Oct 2020 23:12:08 GMT

I was way overthinking it...

CALCULATE( SUM(RevenueChannel[BookedRevenue]), 'Date'[Date] <= _MaxDate - 7, FILTER(ALL('Date'), 'Date'[Date] < TODAY() - 7 && 'Date'[Date] >= TODAY() - 14 ) )

topic Dax - Period To Date This Week Vs. Last Week in DAX Commands and Tips

Dax - Period To Date This Week Vs. Last Week

Re: Dax - Period To Date This Week Vs. Last Week