How do I show in a table the the same field but with a different date range?

[Spudduk]

Thanks in anticpation... Newbie alert....

I have a field X which is linked to a Date. Presently I have no Date Filters on the table so it average the full data set.

What i would like to show is the following in the Table

Product  A   - X(Over full range)     X - Past 8 weeks      X - Past 4 weeks        X - Past weeks.

I can create the individual cards but would like the detail that sits behind it.

Thanks

Andy

[selimovd · Accepted solution]

Hey @Spudduk ,

first create a measure for the total X:

 X(Over full range) = SUM(myTable[Sales Amount])

And then you can create a measure that will filter on the last 8 weeks:

X - Past 8 weeks =
CALCULATE(
    [X(Over full range)],
    DATESINPERIOD(
        'myDateTable'[Date],
        MAX( 'myDateTable'[Date] ),
        -56,
        DAY
    )
)

Past 4 weeks:

X - Past 4 weeks =
CALCULATE(
    [X(Over full range)],
    DATESINPERIOD(
        'myDateTable'[Date],
        MAX( 'myDateTable'[Date] ),
        -28,
        DAY
    )
)

And past week:

X - Past week =
CALCULATE(
    [X(Over full range)],
    DATESINPERIOD(
        'myDateTable'[Date],
        MAX( 'myDateTable'[Date] ),
        -7,
        DAY
    )
)

If you provide sample data it would be easier to give you a working code.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic