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 should be

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

22-------rejected

33--------updtaed1

 

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.

2 Replies

  • 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 !

  • v-xiaotang's avatar
    v-xiaotang
    Community 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.