Forum Discussion
Dynamic variable calendar for column chart
In my report I have a calendar slicer set to "Before". The use case is, users will select the "to date" of the slicer and the report will display data relative to the sele...
PowerBI_Canuck , Not very clear. See if something like this can work
measure =
var _min = minx(allselected('ERP Table'), 'ERP Table'[Date])
var _max = maxx(allselected('Date'), 'Date'[Date])
return
calculate(Sum(Table[Date]), filter( Table, Table[Date] >=_min && Table[Date] <=_max))