Forum Discussion

OldCorps41's avatar
OldCorps41
New Member
3 years ago
Solved

Summarize Filtered by date slicer

I would like to filter a summarized table with a date slicer, I have tried with a connect with a date table and also with a date field in the orginal table: 
SummarizedTable =
SUMMARIZE(
FILTER(
ALL('Daily at a Glance'),
'Daily at a Glance'[Date] >= MIN('Daily at a Glance'[Date]) &&
'Daily at a Glance'[Date] <= MAX('Daily at a Glance'[Date])
),
'Daily at a Glance'[Row], -- Grouping by the Row (index) column
"Total Current Year", CALCULATE(SUM('Daily at a Glance'[Current Year])),
"Total Prior Year", CALCULATE(SUM('Daily at a Glance'[Prior Year]))
)

3 Replies

  • OldCorps41 , A calculated Table and Calculated Column can not use slicer values. so please try use this in a measure

  • Thank you for the quick reply - would I use the same formula but in DAX?