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.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
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.