Reshaping Data from wide to Long

Question

Hello.&nbsp;&nbsp;I am looking or help on best practices for reshaping data in Power BI without using R or Python.&nbsp;&nbsp;I have been given an HR file that contains the following information. Each instance (candidate +recruiter + job + location) has one row and all the events for that instance are columns like this:&nbsp;&nbsp;Person&nbsp;RecruiterPostionlocationEvent1Event2Event3Event41A1234BOSdate1date2date3date41C3567BOSdate5date6date7date82A1368COSdate9date10date11date123B632ATLdate13date14date15date16&nbsp;I need to make all the event columns into two columns event type and date like the table below. Is this possible?&nbsp;Person&nbsp;RecruiterPostionlocationEvent TypeDate1A1234BOSEvent1date11A1234BOSEvent2date21A1234BOSEvent3date31A1234BOSEvent4date41C3567BOSEvent1date51C3567BOSEvent2date61C3567BOSEvent3date71C3567BOSEvent4date82A1368COSEvent1date92A1368COSEvent2date102A1368COSEvent3date112A1368COSEvent4date123B632ATLEvent1date133B632ATLEvent2date143B632ATLEvent3date153B632ATLEvent4date16

amitchandak · Accepted Answer

Try Unpivothttps://radacad.com/pivot-and-unpivot-with-power-bi&nbsp;Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @ Thanks.My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Forum Discussion

Reshaping Data from wide to Long

2 Replies

Related content

Reshape data

Reshape Data

Reshaping Economic Data in PowerBI

how to reshape data

Reshape data

Person	Recruiter	Postion	location	Event1	Event2	Event3	Event4
1	A	1234	BOS	date1	date2	date3	date4
1	C	3567	BOS	date5	date6	date7	date8
2	A	1368	COS	date9	date10	date11	date12
3	B	632	ATL	date13	date14	date15	date16