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
|
1 2 |
QS: SUM({$<Calendar.Year=>} TotalSales) PowerBI: CALCULATE(SUM(TotalSales);FILTER(ALL(Calendar))) |
Open Leads Today = CALCULATE(
[Cum. no. of open Leads];
ALL(‘Calendar’);
FILTER(‘Calendar’;’Calendar'[MonthCurrent] = TRUE())
)