Skip to main content
cancel
Showing results for 
Search instead 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

Reply
learner03
Post Partisan
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  
ArrivedArrived DateFlagged (1/0)
Yes24/02/2022 
no12/02/2022 
no13/02/2022 
no22/02/2022 
Yes21/02/2022 
1 ACCEPTED SOLUTION

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

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

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

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

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

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.