Forum Discussion

v-merpet's avatar
v-merpet
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

Dealing with Blank Values By Using NEXT IN COLUMN

IF I were looking for a Pseudo Code description of my problem it would be this:               --    IF(IsBlank(Value1),Lookup(Value2) RETURN First NON BLANK (Value1)Else(Lookup(Value2) NEXT Row IN C...
Need Help
Tutorial Requests
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi v-merpet ,

     

    We can create a calculated column using following DAX to meet your requirement:

     

    Iteraction_New =
IF (
    ISBLANK ( 'Table'[Iteraction] )
        || 'Table'[Iteraction] = "",
    CALCULATE (
        FIRSTNONBLANK ( 'Table'[Iteraction], TRUE () ),
        FILTER (
            'Table',
            'Table'[WorkID] = EARLIER ( 'Table'[WorkID] )
                && 'Table'[Change Date] >= EARLIER ( 'Table'[Change Date] )
                && 'Table'[Iteraction] <> ""
        )
    ),
    [Iteraction]
)

     


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi v-merpet ,

 

We can create a calculated column using following DAX to meet your requirement:

 

Iteraction_New =
IF (
    ISBLANK ( 'Table'[Iteraction] )
        || 'Table'[Iteraction] = "",
    CALCULATE (
        FIRSTNONBLANK ( 'Table'[Iteraction], TRUE () ),
        FILTER (
            'Table',
            'Table'[WorkID] = EARLIER ( 'Table'[WorkID] )
                && 'Table'[Change Date] >= EARLIER ( 'Table'[Change Date] )
                && 'Table'[Iteraction] <> ""
        )
    ),
    [Iteraction]
)

 


Best regards,