Tag: Weekdays vs Weekends Analysis

Showcasing Workday Number in Power BI Using DAX

We’re going to work through something really unique around Time Intelligence inside Power BI. This technique can help you track and determine the exact workday number in Power BI using a variety of DAX formula and advanced logic. Getting around this analysis can help solve an issue around comparing and counting working days in a

Continue reading

Working Out Sales Periods Using DAX in Power BI: Weekday vs. Weekend

It’s important for many businesses to make sure that you are analyzing over the correct sales periods or correct time periods in which you actually have results. If you implement formulas incorrectly in Power BI, especially with iterating functions like AVERAGEX or SUMX, and you iterate over days when you don’t have results, or days without

Continue reading