Forum Discussion
Applicable88
Impactful Individual
Impactful IndividualCreate Calculated Table and replacing empty values, with the "type"
Hello, unfortunately I got a table which is suboptimal. Here is my sample table: OrderNo. Date Type Materials 11111 01.01.2022 null Felo 11111 01.01.2022 ...
Applicable88 In DAX you could do this:
Column = VAR __OrderNo = [OrderNo.] VAR __Type = MAXX(FILTER('Table',[OrderNo.] = __OrderNo),[Type]) RETURN __Type
Greg_Deckler
Community Champion
Community ChampionApplicable88 In Power Query Editor, use the Fill Up feature. Right-click column header, Fill | Up
Applicable88Greg_Deckler , unfortunately not possible.
Because there are indeed OrderNo. with no Type at all, where empt/null should not be filled up or down. any ideas in DAX? If its a solution in PQ its also good.
- Greg_Deckler
Applicable88 In DAX you could do this:
Column = VAR __OrderNo = [OrderNo.] VAR __Type = MAXX(FILTER('Table',[OrderNo.] = __OrderNo),[Type]) RETURN __Type