Forum Discussion

SimonJF's avatar
SimonJF
Frequent Visitor
8 years ago
Solved

Group and Transpose a Table

Hi Folks, I'm really keen to figure out an efficient way to solve the following data transformation challenge.   I have a monthly report which provides Employment Status (NEW or EW) for a list of ...
dilumd's avatar
dilumd
Impactful Individual
8 years ago

Hi SimonJF,

 

I have tired your case with group function in Power BI, just check whether you’re looking for something like this?

 

SimonJF's avatar
SimonJF
Frequent Visitor
8 years ago

Thanks Dilumd for taking the time.

Unfortunately that doesn't get me the time series table with Month as columns and a unique row of employee name where they have converted from NEW to EW.