Forum Discussion
How to create a dynamic sum filter?
Greetings,
I have this problem encoutered recently; the filter is only filtering by single dates, whereas I would like to filter it as a sum of dates:
This is the actual chart with all dates combined:
This is the granular column I would like to combine together:
Hi Anonymous ,
You could create numeric range slicer instead of using filter.
Using MAX() and MIN() function to get the start and end range.
Then create a measure like below to get value in this range.
calculate([value],filter(all(table),column>=min(slicervalue)&&column<=max(slicervalue)))Best Regards,
Jay
2 Replies
Anonymous You can create a column to group multiple items and then use this colum to filter values. Grouping could be month, week, quarter or anything else which can specifiy.
Hi Anonymous ,
You could create numeric range slicer instead of using filter.
Using MAX() and MIN() function to get the start and end range.
Then create a measure like below to get value in this range.
calculate([value],filter(all(table),column>=min(slicervalue)&&column<=max(slicervalue)))Best Regards,
Jay
