Forum Discussion
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...
created my own working solution)
Previous manager =CALCULATE(MAX('Revenue'[Manager actual]), FILTER('Revenue', 'Revenue'[user]=EARLIER('Revenue'[user]) && 'Revenue'[period] < EARLIER('Revenue'[period])))
created my own working solution)
Previous manager =
CALCULATE(MAX('Revenue'[Manager actual]), FILTER('Revenue', 'Revenue'[user]=EARLIER('Revenue'[user]) && 'Revenue'[period] < EARLIER('Revenue'[period])))