Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm looking a add custome cloumn for latest status of station with dates ...
Solved! Go to Solution.
@SkorpionAAM , my bad one additional )
new column =
var _max = MAXX(FILTER('GasStation',[place_digital_adress]=EARLIER([place_digital_adress])),[Date])
return
MAXX(FILTER('GasStation',[place_digital_adress]=EARLIER([place_digital_adress]) && [Date] = _Max),[STATUS_OF_STATION])
@SkorpionAAM , I think new column show be like this
new column =
var _max = MAXX(FILTER('GasStation',[place_digital_adress]=EARLIER([place_digital_adress])),[Date])
return
MAXX(FILTER('GasStation',[place_digital_adress]=EARLIER([place_digital_adress]) && [Date] = _Max)),[STATUS_OF_STATION])
Max of date for place_digital_adress
gettting error
@SkorpionAAM , my bad one additional )
new column =
var _max = MAXX(FILTER('GasStation',[place_digital_adress]=EARLIER([place_digital_adress])),[Date])
return
MAXX(FILTER('GasStation',[place_digital_adress]=EARLIER([place_digital_adress]) && [Date] = _Max),[STATUS_OF_STATION])
User | Count |
---|---|
93 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
115 | |
106 | |
85 | |
65 | |
64 |