Forum Discussion
Date Filter
You need to use a disconnected calendar table.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Hi lbendlin uploaded a new files here.
If you go into power query editor of my data, there is a filter set on the dates and services.
Date filter conditions to get December 2023 numbers is:
Start dates will be all dates pre 31 December 2023 will be selected. Anything after will be unchecked.
End dates will be all dates post 1 December 2023 will be selected. Anything before will be unchecked.
There is also a filter on the Services.
After setting this filters, the sum of December 2023 will be 692k.
My issues are:
1) how do i set the same date filter for each month of the year.
2) how to display it properly. As you can see the 629k is distributed across 2021-2023. I only need the 629k to be displayed for December 2023.
Appreciate your help.