Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

First non blank Value

I need to calculate First status of Id ID             Status 12 ----------active 12----------updated2 12---------failed 22-------rejected 33--------updtaed1 33--------updated2     Result ...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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's avatar
gauthamboppana
Solution Specialist
4 years ago

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 !