Forum Discussion
learner03
Post Partisan
Post PartisanMinus 2 days except Weekend
I Have to make a Flagged column based on following condition- If Arrived date minus 2 days except weekend/holiday has Arrived as NO, then 0 If Arrived date minus 2 days except weekend/holiday has A...
learner03 , try like
new column =
var _rank = maxx(filter('date', 'date'[Date] = table[Arrival date] +2), date[Work Date cont Rank])
return
maxx(filter('date', 'date'[Work Date cont Rank] = _rank), date[date])
learner03Post Partisan
Post Partisanamitchandak I understood the blog, but unable to apply in relation to my query related to minus 2 with arrived date
amitchandak
Super User
Super Userlearner03 , Try a new column in you table, using date table
new column =
var _rank = maxx(filter('date', 'date'[Date] = table[Arrival date] +2), date[Work Date cont Rank])
return
maxx(filter('date', 'date'[Work Date cont Rank] = _rank), date[date])