Tag: DATESBETWEEN function

Calculate Workdays Between Two Dates In Power BI

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

Continue reading

Calculate Rolling Totals Using DATESBETWEEN In Power BI

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. Another way to think about this is calculating rolling sales or running totals. We need the calculation to be dynamic, so that as we move through time, we have a number

Continue reading