Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
"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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
83 | |
82 | |
65 | |
49 |
User | Count |
---|---|
135 | |
111 | |
100 | |
65 | |
62 |