Category: DAX
06
Jul
Use aggregate functions on rows in Power BI
by Nikola
8 Comments
Using aggregate functions on columns is fine, but doing same on rows is - pure beauty! And all this with a single line of DAX...
04
Jul
TIQ Part 3 – Ultimate Guide to Date dimension creation
by Nikola
2 Comments
In third part of TIQ series, learn all available methods for creating proper Date dimension in Power BI
27
Jun
TIQ Part 2 – Your Majesty: Date Dimension
by Nikola
No Comments
What is so special about Date dimension in Power BI data model? Find out in the second part of TIQ series
22
Jun
TIQ Part 1 – How to destroy your Power BI model with Auto Date/Time
by Nikola
4 Comments
In the first part of TIQ Series, find out why using Auto Date/Time is a bad idea
21
May
Drillthrough like a PRO in Power BI
by Nikola
No Comments
Use dynamic formatting of the buttons to create awesome user experience for your Power BI reports
03
May
Role playing dimensions in Power BI
by Nikola
No Comments
Check this simple modeling technique to avoid data model redundancy
29
Apr
Override date filter in Power BI
by Nikola
2 Comments
Overriding standard date filtering can be trickier than you can imagine