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)
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)
Ok now it makes sense to me, kind of new to power bi. thank you.