Forum Discussion
Dynamic 13 weeks based on baseweek selection slicer
Hi All, I am new to Power BI. Can anyone please help me on dynamic 13 week selection based on my base week slicer. Eg, if i select 202013 then i need the output as 202001 to 202013 if i s...
Icey I have used Lookupvalue and hasonevalue to get my requirement.
Below are the measures which i have used.
13 WKS =
CALCULATE(SUM('TM Trend'[Sat_Day_Test_Count]), DATESBETWEEN('calendar'[Reference_Date], [CUS_CY13W_Start], [CUS_CY_BaseDate]))CUS_CY13W_Start = LOOKUPVALUE('Calendar'[CUS_CY13W_StartDate], 'Calendar'[CUS_CY_Baseweek], [CUS_CY_BaseWeek_Selected])CUS_CY_BaseWeek_Selected = IF(HASONEVALUE('Weeklist'[Base Week]), VALUES('Weeklist'[Base Week]), BLANK())
Hi Anonymous ,
Please let us know whether this problem has been solved.
Best Regards,
Icey
Icey I have used Lookupvalue and hasonevalue to get my requirement.
Below are the measures which i have used.
13 WKS =
CALCULATE(SUM('TM Trend'[Sat_Day_Test_Count]), DATESBETWEEN('calendar'[Reference_Date], [CUS_CY13W_Start], [CUS_CY_BaseDate]))
CUS_CY13W_Start = LOOKUPVALUE('Calendar'[CUS_CY13W_StartDate], 'Calendar'[CUS_CY_Baseweek], [CUS_CY_BaseWeek_Selected])
CUS_CY_BaseWeek_Selected = IF(HASONEVALUE('Weeklist'[Base Week]), VALUES('Weeklist'[Base Week]), BLANK())