Forum Discussion
Cbutler
Helper III
Helper IIICalculated table filter by N days
Help! I am trying to create a calculated table that filters by a dynamic date to pull back the results for the last n or 10 days. So I need a calculated table that is written to show the MAX ...
CbutlerHelper III
Helper IIIGreg_Deckler oh thats got me closer, but the as at date is not changing the table filter.
Its filtering from MAX table date (today) -10 so pulling data form 15-24th (no data in there for today), but when I change my filter as below...I need the table to recalculte the -10 days, so selecting 15/10/21 would filter the table to show 6/10/21 to 15/10/21...
Greg_Deckler
Community Champion
Community ChampionCbutler Yeah, so if you use that as an actual table, it will not be dynamic but only caculated at load time. You will have to put it as a VAR within your other measures to make it truly dynamic. It's such a pain that measures cannot return tables. That would make things sooooo much simpler and better.