cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Partisan

## Minus 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 Arrived as Yes, then 1

For identifying weekend/holiday, I have calender table where there is a column that says 1 for workday and 0 for weekend/holiday.

 Product Arrived Arrived Date Flagged (1/0) Yes 24/02/2022 no 12/02/2022 no 13/02/2022 no 22/02/2022 Yes 21/02/2022
1 ACCEPTED SOLUTION
Super User

@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])

5 REPLIES 5
Super User
Post Partisan

@amitchandak i saw your pbix and the +10 days is a measure. How can I have this as a calculated column?

Super User

@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])

Post Partisan

@amitchandak I understood the blog, but unable to apply in relation to my query related to minus 2 with arrived date

Super User

@learner03 , 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])

Announcements