How to Create MTD / QTD / YTD Time Intelligence Slicer & Dynamic Title in Microsoft POWER BI
Rahim Zulfiqar Ali
0:00 / 0:00
How to Create MTD / QTD / YTD Time Intelligence Slicer & Dynamic Title in Microsoft POWER BI
5 992 просмотра · 1 год назад
Rahim Zulfiqar Ali
54,9 тыс. подписчиков
5 992 просмотра · 1 год назад
How to Create MTD / QTD / YTD Time Intelligence Slicer & Dynamic Title in Microsoft POWER BI
Selected Time Period Sales =
VAR SelectedPeriod = SELECTEDVALUE(TimePeriods[TimePeriod])
RETURN
SWITCH(
SelectedPeriod,
"MTD", [Current MTD],
"QTD", [Current QTD],
"YTD", [Current YTD],
Blank())
Dynamic Title = "Sales by "& SELECTEDVALUE(TimePeriods[TimePeriod])