Tag: DATESBETWEEN function

Calculate Workdays Between Two Dates In Power BI

By Brian Julius, Enterprise DNA Expert on September 28, 2020July 27, 2021

Calculating Workdays Between Two Dates in Power BI

I’m going to show you how to calculate workdays between two dates either with the holidays counted or without the holidays. This is a topic that’s been asked over and over again on the Enterprise DNA Forum. I also believe that this will be a great way to close this Time Intelligence series, knowing that

Posted in: DATESBETWEEN function, Time Intelligence, Time Intelligence Calculations, Time Intelligence DAX, Time Intelligence Examples, Time Intelligence Power BI, Workday and Weekday Numbers, Workdays DAX

DAX Power BI Time Intelligence

Calculate Rolling Totals Using DATESBETWEEN In Power BI

By Sam McKay, CFA on January 1, 2020June 10, 2021

Here I’m going to show you how you can calculate the amount sold between two different dates using the DATESBETWEEN function in Power BI. You may watch the full video of this tutorial at the bottom of this blog. Another way to think about this is calculating rolling sales or running totals. We need the

Posted in: Between two dates, DATESBETWEEN function, DAX Calculations, DAX Measures, Power BI DATESBETWEEN, Rolling Sales, Rolling Totals, Running Totals