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...
amitchandak
Super User
Super UserPowerBI_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))