Forum Discussion

zfemmer's avatar
zfemmer
Icon for Helper I rankHelper I
5 years ago
Solved

Dax - Period To Date This Week Vs. Last Week

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(RevenueC...
DAX
measure
  • zfemmer's avatar
    zfemmer
    5 years ago

    I was way overthinking it...

    CALCULATE(
    SUM(RevenueChannel[BookedRevenue]),
    'Date'[Date] <= _MaxDate - 7,
        FILTER(ALL('Date'),
        'Date'[Date] < TODAY() - 7 &&
        'Date'[Date] >= TODAY() - 14
        )
)
zfemmer's avatar
zfemmer
Icon for Helper I rankHelper I
5 years ago

I was way overthinking it...

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