Forum Discussion
Solved
Removing blanks from a defined variable in DAX/Power Query
Hi all, This is driving me crazy. In my calculated table I want to remove the rows which contain a blank. A very simple task but I can't get it working. Any help is appreciated! I combine to co...
You can use
Bridge SO = VAR MNSO = FILTER ( DISTINCT ( mn_rcpl[ServiceOrderNumber] ), NOT ISBLANK ( mn_rcpl[ServiceOrderNumber] ) ) VAR PUSO = FILTER ( DISTINCT ( 'Parts Usage Frequency Report - Raw Data'[Service Order] ), NOT ISBLANK ( 'Parts Usage Frequency Report - Raw Data'[Service Order] ) ) VAR CombinedSO = DISTINCT ( UNION ( MNSO, PUSO ) ) RETURN CombinedSO
