Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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())
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi I have the following scenario, as you said i have achived the measures for the past 13 week.
Based on the date selected my measures will show low/high/avg of call time through measure.
In the same report i need to show a line chart which should show the past 13 weeks trend like based on the date selected.
Could please let me know how to do this?
Dynamically changing calculated columns are not available in power bi. also measure will return only one value. but in my case if a date is selected i need to show the past 13 week in trend like.