Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Variable with last date selection

Hi, As you can see below i have for tyhis Invoice-nr different ststus registration in colomn WBRKC101. I want to have the last status which is FS with date 09/22/2021. How can i  doe it? Please he...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Yours is a column, not a measure. If you want a column, please try:

    Column = 
var _lastDate=CALCULATE(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[Invoic-nr.]))
return IF([Date]=_lastDate,[Status],BLANK())

     

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

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Try a measure like

 


Measure =
VAR __id = MAX ('Table'[Invoice-nr] )
VAR __date = CALCULATE ( MAX('Table'[date] ), ALLSELECTED ('Table' ), 'Table'[Invoice-nr] = __id )
CALCULATE ( MAX ('Table'[Status] ), VALUES ('Table'[Invoice-nr] ),'Table'[Invoice-nr] = __id,'Table'[date] = __date )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Amitchandak,

    Thank you for your quick answer!
    Wat i actualy want is this: Fill column "Actual Status" as a nieuw measure with status with newst/latest date.

     

    Thank You!