Forum Discussion
How to create a measure with a filter between two dates
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)
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.
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?
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.