Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Business Date Using "New Column", Instead of "New Measure"

"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. 


Super User III
Super User III

Re: Business Date Using "New Column", Instead of "New Measure"

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:


Here's somebody having a similar issue of finding business days between two dates:

Helpful resources

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors