Forum Discussion

mgils24's avatar
mgils24
Regular Visitor
1 year ago
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...
  • johnt75's avatar
    johnt75
    1 year ago

    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
johnt75's avatar
johnt75
Super User
1 year ago

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