Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Compare strings in previous month

Hello. I need a DAX Measure to count how many staff employees got promoted into a leadership position. This is what my data looks like. So it would need to return 1 because 101 was staff. 102's promo...
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
5 years ago

Power BI is easy when you prep your data. I would add a conditional column using Power Query to indicate if the Mgr level is considered to be a staff promotion. Then you can write a simple DAX formula

CALCULATE(COUNTROWS(Table),table[promotion]="Promotion",table[new column]="from staff")