Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a Table 1.
This a table with consisting of dates when limits changed and actual limits.
I also have a slicer with dates.
I want - when i select a date in the slicer, it would show me the actual limit from table 1. if the dates do not match, it needs to show me the last actual dates limit before the date in the slicer..
@Elmarius123 , You an get a date like
measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = mainx(allselected(Date),Date[Date])
return
calculate(Max(Table[Date]), filter(Table, Table[Date] >= _min && Table[Date] >= _max))
or you use this max date to calculate other thing
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
86 | |
46 | |
28 | |
22 |