slicer values
1 Topic
get minimum of selected slicer column values, in a table showing the selected column.
slicer: yearmonth selected: 2023-09 and 2023-10 table yearmonth | salesvalue 2023-09 | 1234 2023-10 | 4321 what I want to add is the accumulated sales in the selected period. table yearmonth | accum.sales 2023-09 | 1234 2023-10 | 5555 for this I need the minimum and maximum of the selected slicer values, to get the filter in dax: yearmonth >= MinYearMonth, yearmonth <= MaxYearMonth. How to get the Min and MaxYearMonth? Because in the table itself the selectedvalue of yearmonth becomes the single value of the line in the table: either 2023-09 of 2023-10, not both. Thanks!Solved1.3KViews0likes2Comments