Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Highlight changed value over time

Hi All,   I was wondering if someone could help me out.  We are forecasting our employee schedule for +8 weeks 'Forecast'[t+]. We change the record type from Employee to Idle if someone's commitm...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi Anonymous,

     

    First, what's your expected based on this sample data?

     

    If you want to compare the Commitment rate between current week and last week. You can try following calculated column:

     

    Last Week value =
IF (
    ISBLANK (
        LOOKUPVALUE (
            'Table'[Commitment rate],
            'Table'[Employee_ID], 'Table'[Employee_ID],
            'Table'[t+], 'Table'[t+] - 1
        )
    ),
    'Table'[Commitment rate],
    LOOKUPVALUE (
        'Table'[Commitment rate],
        'Table'[Employee_ID], 'Table'[Employee_ID],
        'Table'[t+], 'Table'[t+] - 1
    )
)

     

    You can check the sample report here: https://1drv.ms/u/s!AlqSnZZUVHmshXQ7rxV2bFmtAamf 

     

    Thanks,
    Xi Jin.

v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Hi Anonymous,

 

Please kindly share us some sample data which we can copy and paste directly and its corresponding expected result. So that we can get a right direction and provide some proper suggestion.

 

Thanks,
Xi Jin.