Tag: DATESBETWEEN function

Calculate Workdays Between Two Dates In Power BI

Calculating Workdays Between Two Dates in Power BI, power bi datediff working days post image

I’m going to show you how to calculate workdays  / working days 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

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

Continue reading