DAX Handbook
A chapter-by-chapter guide to DAX - read it like a book, with a syllabus that keeps your place.
55 articles
Divorces in Slovenia - Stable in Numbers, Shifting in Nature
March 23, 2026
Marriages in Slovenia - Declining and Shifting
March 16, 2026
Who Visits Slovenia and When
March 9, 2026
Where Slovenians Travel and When
March 2, 2026
Newborn Names - A Growing Pool
February 23, 2026
Newborn Names - Getting Shorter
February 16, 2026
Newborn Names - Changing Popularity Over Time
February 10, 2026
We have expanded our team again!
February 3, 2026
Advanced Excel training for client Hilding Anders
September 30, 2025
Business improvement with the help of Power BI
September 23, 2025
The main budgeting mistakes in Excel
September 11, 2025
New Power BI training held for client Bugatti Rimac
March 3, 2025
Held PowerApps training for Žito d.d.
January 27, 2025
This year's first PowerApps training for TÜV NORD Adriatic
January 20, 2025
Held Excel training for Eksa Grupa
December 30, 2024
New employee in the team!
December 2, 2024
Participation in the Microsoft 365 conference
November 8, 2024
A three-day PowerBI training was held for client Bugatti Rimac
October 17, 2024
Held Excel training for client BDC
October 8, 2024
Dynamic Coalesce in PowerQuery
February 8, 2022
Dynamic bulk insert to Power Apps collection
August 26, 2021
Bulk insert to Power Apps collection
August 17, 2021
Why should you start using Power Apps?
August 3, 2021
Merging with date range using Power Query
June 2, 2021
How to process multiple folders with a single PowerQuery script
February 23, 2021
Dynamically expand table or record columns in Power Query
February 2, 2021
Sorting in Matrix created with calculation groups (PowerBI)
January 7, 2021
Conditional formatting with Calculation Groups in PowerBI Matrix visual
December 8, 2020
How to track changes in the table in Power Query
December 1, 2020
Split packs into single products in Power Query
November 24, 2020
Nested functions and Table.Buffer()
November 4, 2020
Dynamically remove top rows in Power Query
October 28, 2020
List.Generate() and Looping in PowerQuery
October 20, 2020
Using M to dynamically change column names in PowerQuery
October 13, 2020
Including hours and minutes in DAX date filters
August 17, 2020
Incremental refresh using PowerBI pro and Dataflows
December 5, 2019
Pivottables inside the PowerBI - The DAX way
September 5, 2019
How to split budgets to lower granularity with DAX (PowerBI)
July 11, 2019
Optimizing distinctcount with reduced memory consumption in PowerBI (VertiPaq)
February 12, 2019
PowerBI One Measure for Multiple Dimensions/Facts - DAX
October 30, 2018
PowerBI vs Microsoft Excel trends by Google
October 15, 2018
Why should you start learning PowerBI?
September 3, 2018
How to use a new PowerBI Mapbox visual
August 29, 2018
World Cup Russia 2018 PowerBI interactive dashboard
July 13, 2018
Dynamic ABC analysis in DAX-variables
April 24, 2018
![EU Countries Inflation rates since 2005 [PowerBI interactive Dashboard]](/uploads/Capture_smanjeno.jpg)
EU Countries Inflation rates since 2005 [PowerBI interactive Dashboard]
February 14, 2018
Temperature Averages in Croatia (PowerBI Interactive Dashboard)
January 22, 2018
How to use Measures in Excel
December 27, 2017
Power BI Pricing Options
December 1, 2017
The next generation of data analysts
November 23, 2017
The most important DAX concepts
November 18, 2017
DAX - the brain of a PowerPivot
November 9, 2017
Power BI - Complex BI Solution at a fraction of a price
November 1, 2017
Power Pivot - PivotTable brother on steroids
October 24, 2017
Power Query - Powerful Excel feature you should start using right away
October 16, 2017