The dynamic ratio of top X products to the rest
It would be best to give users different data exploration options when creating analytical views. This is one of the practical options.
Everything that has already been written
It would be best to give users different data exploration options when creating analytical views. This is one of the practical options.
Document your code! One day you will thank yourself, or someone else will thank you, who will take over.
Dataflows have been with us in Power BI for some time now, and people have gotten more used to them. However, as their popularity grows, so does the need to control them.
There is an abundance of APIs around us, and we use them in our daily routine without thinking about them anymore.
The data dimension is one of the most fundamental dimensions needed in reporting. That is because we are primarily interested in results from the point of view of the passage of time.
The WINDOWS function is becoming very popular because it can save a lot of time both for the execution of the calculation and for the development itself. At the same time, this is the last of the new functions I need to test against Calculation Groups.