Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
I want to create the Working Days Date Table with Cut-Off timing i.e. 06:00PM EST after 06:00PM Est it should consider the next day
I was successful creating the Working Date Table but unable to put the Cut - Off timing for each working day.
This may be achievable in Power Query editor, if you can provide small piece of data with few Dates and times , i will try to help!
Proud to be a Super User!
I have a Date Table in which I have excluded the Non Working Days i.e. US Holidays and Weekends.
Now i want Each day Cut-Off time till 06:00 PM EST after 06:01 PM EST it should count the next working day
For E.g
Feb 16th at 05:30PM EST is Feb 16th
But
Feb 16th after 06:01 PM EST should be Feb 17th (Next business Day)
Hope my question is clear now
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 130 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |