Forum Discussion
How to create a measure with a filter between two dates
I got a quick question
I got for example the following range of dates
And I have a measure that is sum of sales.
I am wondering is there a way to create a measure that filter based on the date range the user choose in the slicer.
For example I want to return the sum of sales if the user chose between 8/21/2022 and 2/20/2023 or between
9/21/2022 and 1/1/2023 for example
Cant you do this by adding the regular slicer available in powerbi?
Adding the slicer visual will automatically add filter context to your visual/measures. I just did a simple test here with my database, summing the amount of items ordered by item code. When you change the date range it automatically updates those sums to the total that is within that set date range. (In my case WODueDate_CC)
5 Replies
Cant you do this by adding the regular slicer available in powerbi?
Adding the slicer visual will automatically add filter context to your visual/measures. I just did a simple test here with my database, summing the amount of items ordered by item code. When you change the date range it automatically updates those sums to the total that is within that set date range. (In my case WODueDate_CC)
Sure I can post like an excel type of example
I got something like this. My rows are the warehouses. My column are the dates for example 8/21 to 9/21 and I chose these two dates based on a date filter. My values is the total sales for that particular day.
I would like a column that sums up the total sales between these two periods 8/21 to 9/3. But
I also have a date slicer and I would like the sum to change based on the dates chosen.