In this blog post, we will deal with some troublesome issues in time intelligence, particularly those issues caused by week granularity and the troubles that can be caused by the irregular number of weeks in a year. We’ll use offsets to come up with accurate time intelligence in DAX. We have an interesting scenario for
In this blog post, I’ll be bringing you the solution for working with timetables in Power BI, which is our Problem of the Week #10. This wasn’t an overly difficult challenge. But still, it was quite a niggly one that threw in quite a few curveballs. You can watch the full video of this tutorial
This tutorial will teach you about different iterating functions and how to efficiently use them in your calculations. I often discuss how calculated columns are not required when making some calculations. This is because of iterators. Iterators or iterating functions can help you do a calculation without physically putting the results in the table. This
Now, let’s delve deeper into one of the most important concepts in Power BI calculations — the aggregations. Power BI aggregations are formulas used to calculate a single summarized value from multiple rows that are grouped together. There are different ways to create aggregations in Power BI. Some of the examples of aggregation functions are
