First non blank Value

[Anonymous]

I need to calculate First status of Id

ID             Status

12 ----------active

12----------updated2

12---------failed

22-------rejected

33--------updtaed1

33--------updated2

Result should be

12 ----------active

22-------rejected

33--------updtaed1

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Thanks for reaching out to us.

You can try this,

or if there is date/index column in that table, you can  try

Measure = 
var _minIndex=CALCULATE(MIN('Table'[Index]),FILTER(ALLEXCEPT('Table','Table'[ID]),'Table'[Status]<>BLANK()))
return MAXX(FILTER(ALL('Table'),'Table'[Index]=_minIndex),[Status])

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[gauthamboppana]

@Anonymous   - Try the below and let me know if it works.

CALCULATE (
    FIRSTNONBLANK ( LookupTable[Status], TRUE () ),
    FILTER (
        LookupTable,
           LookupTable[ID] = TargetTable[ID] )
    )
)

Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !