Forum Discussion
Help with DAX
If you're actually replacing/editing data in the data set, the best way is to use Power Query. DAX is for analyzing the data afterwards.
In the query editor, you can use replace to find all instances of "not set" and replace them with null values. Then you can order the data as needed and fill down to fix the Product List Name. If you want the second column instead of fixing the original, then copy the column and do the same thing.
Note that the fill down has potential to give you funky results if the first item when ordered by Transaction ID is a blank.
Does it have to be DAX? Would a simple 'Fill Down' in Power Query editor meet the requirement?
If you're actually replacing/editing data in the data set, the best way is to use Power Query. DAX is for analyzing the data afterwards.
In the query editor, you can use replace to find all instances of "not set" and replace them with null values. Then you can order the data as needed and fill down to fix the Product List Name. If you want the second column instead of fixing the original, then copy the column and do the same thing.
Note that the fill down has potential to give you funky results if the first item when ordered by Transaction ID is a blank.