Allgemeines Allgemeines

Qlik Sense SetAnalysis and Power BI Dax Comparisson

For my new job I have to move my skills from qlik to microsoft power bi which – at the beginning – is quite challenging. So to keep a bridge in my mind and to speed up my knowledge curve, I document here the samples on how thinks work in qlik sense/view and how in Power BI. Maybe some of the examples need more explanation? Feel free to ask, otherwise it’s as short as possible, so I can keep an overview.

Total Sales for all years

QS: SUM({$<Calendar.Year=>} TotalSales)
PowerBI: CALCULATE(SUM(TotalSales);FILTER(ALL(Calendar)))

1 Anwort auf „Qlik Sense SetAnalysis and Power BI Dax Comparisson“

Schreibe einen Kommentar