The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I want to apply DAX formula to calculate the next_business_day in a Calendar table.
If the date is holiday (i.e. if_work_day = 0) then next_business_day = date+next working day.
What should be the DAX formula for this?
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new column.
Next_business_day CC =
MINX (
FILTER (
'Calendar',
'Calendar'[Date] > EARLIER ( 'Calendar'[Date] )
&& 'Calendar'[If_work_day] = 1
),
'Calendar'[Date]
)
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new column.
Next_business_day CC =
MINX (
FILTER (
'Calendar',
'Calendar'[Date] > EARLIER ( 'Calendar'[Date] )
&& 'Calendar'[If_work_day] = 1
),
'Calendar'[Date]
)
User | Count |
---|---|
25 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |