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,

     

artemus's avatar
artemus
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

This is more easily accomplished in power query, if you don't mind changing the dataset to include these values.

 

Simply go to edit query, select the iteration column, and choose fill up.

 

If you need some help with this, just ping me on teams.