Forum Discussion

Tooba_kazmi's avatar
Tooba_kazmi
Icon for Helper I rankHelper I
3 years ago

Measure KPI for this week versus last week

Hi, I want to measure KPI for this week versus last week with the following code but its not working for last week. Please help.   Current_Week = Var _select = SELECTEDVALUE('S&R and PE data'[W...
Need Help
sergej_og's avatar
sergej_og
Icon for Super User rankSuper User
3 years ago

Just an idea...what about using OFFSET function?
I had a similar case last week. Solved with OFFSET function.
Instead of your FILTER-Part try OFFSET function.

  • Tooba_kazmi's avatar
    Tooba_kazmi
    Icon for Helper I rankHelper I
    3 years ago

    Hi, 

    Offset is also giving me "Blank" in Last week's measure. 

    • sergej_og's avatar
      sergej_og
      Icon for Super User rankSuper User
      3 years ago

      As v-zhangti mentioned provide pls more information.
      OFFSET works fine for me.

       

      • Tooba_kazmi's avatar
        Tooba_kazmi
        Icon for Helper I rankHelper I
        3 years ago

        Hey, thanks for your time but i solved the problem after referring the date from the date table.