Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
"Ordered Date" + "VSLA" (n-days) = "Business Dates" (Adjusted Order Date)
What I want to achieve is simple in Excel, but it's difficult in Power BI.
I've gone through 3 posts related to this question but no way out for me.
I do this in Excel so it's like this.
In PowerBI, I hope to see the output to be created by "New Column" in my table called "Table1", instead of "New Measure". Clearly, what I have in the image is incorrect.
Any direction would be helpful.
Thanks in advance.
The easiest way to accomplish this is to set up a date dimension, and mark days as business days on that. Then you can do the math pretty easily from there: https://radacad.com/do-you-need-a-date-dimension
Here's somebody having a similar issue of finding business days between two dates: https://community.powerbi.com/t5/Desktop/calculate-number-of-working-days-between-2-dates/td-p/55456
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 18 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 51 | |
| 38 | |
| 31 | |
| 26 |