Power BI

„Excel or Power BI?” is one of the most common questions once reports start to grow. And it’s usually asked…

Learn how the entire Power BI process works – from data preparation with Power Query, through the data model and DAX calculations, to visualizations and KPIs.

Learn how to publish a Power BI report through Power BI Service and embed an interactive chart on a website using Publish to web.

Learn how to build KPIs in Power BI using DAX – target achievement, sales growth, and how filter context affects your metrics.

Learn how DAX Time Intelligence functions calculate YTD, MTD, comparisons to last year, and moving periods in Power BI.

Learn the difference between Row context and Filter context in DAX, how they work together, and how CALCULATE changes filter context in Power BI.

Learn how DAX functions ALL, REMOVEFILTERS, and KEEPFILTERS control filter context in Power BI – differences, examples, and when to use each.

Learn how the DAX CALCULATE function works in Power BI – syntax, examples, changing filter context, and common mistakes.

Learn how DAX iterator functions SUMX, AVERAGEX, COUNTX, and RANKX work in Power BI, the difference from SUM, and when to use them.

Learn the differences between DAX COUNT, COUNTA, COUNTROWS, DISTINCTCOUNT, and COUNTX functions in Power BI – and when to use each.