How to create a measure with a filter between two dates

[Anonymous]

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

[Anonymous]

I have date in my columns between those period but its like I am trying to calculate a grand total where you add all the dates between two periods. 

[Anonymous]

Hmmm I guess I am not understanding what you are going for then. Could you post an example set of data and the expected return? Also what is your current measure for summing the sales? 

[Anonymous]

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. 

[Anonymous · Accepted solution]

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)

[Anonymous]

Ok now it makes sense to me, kind of new to power bi. thank you.