This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
"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
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 31 | |
| 24 | |
| 23 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 63 | |
| 38 | |
| 28 | |
| 23 | |
| 22 |