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“
Open Leads Today = CALCULATE(
[Cum. no. of open Leads];
ALL(‘Calendar’);
FILTER(‘Calendar’;’Calendar'[MonthCurrent] = TRUE())
)