Forum Discussion

BeginnerAnalyst's avatar
BeginnerAnalyst
Frequent Visitor
3 years ago
Solved

dax calculated column with previous manager

Hi, friends, Here is example of my table in power BI: user period manager historical manager actual previous manager user1 01.01.2023 manager 1 manager 2 manager 1 user1 01.02...
  • BeginnerAnalyst's avatar
    BeginnerAnalyst
    3 years ago

    created my own working solution) 

    Previous manager =
    CALCULATE(MAX('Revenue'[Manager actual]), FILTER('Revenue', 'Revenue'[user]=EARLIER('Revenue'[user]) && 'Revenue'[period] < EARLIER('Revenue'[period])))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi BeginnerAnalyst ,

I'm a little confused about your needs, Could you please explain them further? 

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu