Using DAX, show data of previous 2 months, 5 weeks, 7 days

[ovetteabejuela]

Hi again,

SO by using a DAX formula, how can I show data for

2 months: this month and the previous

5 weeks: this week and previous 4

7 days, today and previous 6

I want to end up with this:

[Greg_Deckler]

So, in generaly, you are going to do this by wrapping an aggregation function with a CALCULATE with the appropriate filter. You may need to add some additional columns to your data that calculate some of this information using TODAY. For example, if you want the number of days from TODAY, you could do this:

DaysAgo = IF([Date]<TODAY(),DATEDIFF([Date],TODAY(),DAY),BLANK())

You could then do something like this:

Measure = CALCULATE(SUM(<column>),[DaysAgo]<6)

[ovetteabejuela]

Hi @Greg_Deckler,

Thanks, I see what you're trying to suggest and I'm trying it out now.