Forum Discussion
Automate Weekly Update
Hello,
I have a table that filters out upcoming deadlines according to week. There is the text table containing the deadlines and descriptions and the the week gets updated in the filter pane.
The filter pane is based on a calculated measure of the week number for the that deadline. Every week, I change the number to match the current week so that only the relevant deadlines appear. Is there a calculated measure I can create so that I would not have to go into the filter pane to increase the number by 1 each week?
Obligatory warning: it will break when you cross year boundaries. You will also need to define what you mean by "week" (ideally by providing a precompiled calendar table).
Here's the general pattern:
- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app
3 Replies
- lbendlin
Super User
Obligatory warning: it will break when you cross year boundaries. You will also need to define what you mean by "week" (ideally by providing a precompiled calendar table).
Here's the general pattern:
- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app- lbendlin
It assumes that the calendar table is in Import Mode, and is refreshed frequently (daily)