create column
1 Topic
Create new columns with first and last header retrieved from component and header column
Hi all, I have data of the column Component and Header available and want to create to extra columns which return the start and end header like in the example below. Anyone who knows how to do so? (either in DAX (measure or calculated column) or PowerQuery). So you go from 1-->2-->3-->4 which means the start header is 2 and end header is 4 So you go from 5-->6-->7-->8 which means the start header is 6 and end header is 8 Component Header StartHeader EndHeader 1 2 2 4 2 3 2 4 3 4 2 4 5 6 6 8 6 7 6 8 7 8 6 8 KR, LarsSolved2.4KViews0likes13Comments