Tag: MIN function

Time Intelligence In DAX: How To Dynamically Select Starting Period

Power BI Dynamically Select Starting Period

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

Continue reading

Time Tables In Power BI: Solution For POTW #10

Time Tables In Power BI- Solution For POTW #10

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

Continue reading

How To Use An Iterating Function In Power BI

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

Continue reading

Understanding Power BI Aggregations

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

Continue reading