Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 |
Solved! Go to 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])
@learner03 , refer to my blog
Traveling Across Workdays - What is next/previous Working day
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calenda...
@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])
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
61 | |
56 | |
55 | |
36 | |
34 |
User | Count |
---|---|
77 | |
73 | |
45 | |
45 | |
43 |