Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

difference between rows within a category

Hello, I am using power querry for data processing and I need help getting the difference between rows.  I have a table that has the following rows and columns: Country     Code    Region     Stage...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

Please follow Greg_Deckler and edhans 's suggestions, provide more details.

As i assumed, if "Stage" from your table refers to "phase" in your statement,

and your requirement is like stage1,2,3 have different end dates,

then you could add conditional column like the following:

As for another requirement: "count how many employees i need each month", 

Do you mean to count the employees who are between start date and end data?

 

Best Regards

Maggie

sss