Qlik → Power BI, one function at a time
Free, neutral reference for teams moving from QlikView or Qlik Sense to Power BI and Microsoft Fabric. Every page shows the Qlik original, the DAX / Power Query / modeling equivalent, and where the behaviour differs, with links to the official docs.
Direct equivalent Partial / different approach No 1:1 equivalent
Browse by category
Set Analysis 7
Qlik set expressions and how to express the same filter logic with CALCULATE, filter arguments and table functions in DAX.
Aggregation & chart functions 8
Aggr, TOTAL, Count distinct, Only, Concat, FirstSortedValue, Rank and other chart-level functions translated to DAX.
Inter-record & running totals 3
Above, RangeSum, moving averages and other row-to-row chart logic, mapped to DAX window functions and visual calculations.
Conditional, string & null logic 5
If, Match, WildMatch, Pick, Dual and null handling, and the case-sensitivity and BLANK differences that trip people up.
Date & time 6
MonthStart, AddMonths, YearToDate, Date# parsing, NetWorkDays and building a calendar table.
Load script & transformations 13
Qlik load script statements and prefixes (ApplyMap, Peek, Resident, Join, CrossTable, IntervalMatch…) translated to Power Query M or Fabric.
Data model, security & variables 5
Synthetic keys, alternate states, Section Access, variables and incremental QVD loads, and what replaces them in a Power BI semantic model.
Migration tools & partners
Converters, accelerators and consultancies that specialise in Qlik → Power BI work, described neutrally.