cancel
Showing results for
Did you mean:
Frequent Visitor

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

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

1 ACCEPTED SOLUTION
Super User

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

Super User

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