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.

Whitewater100's avatar
Whitewater100
Solution Sage
4 years ago

Hi:

 

You can use MAX(TableName[Date]) and filter in a visualization.

 

If you want to be specific about FS:

Calculate(MAX(TableName[DATE]),
FILTER(TableName,
TableName[Status] = "FS")
)
 
I hope this helps!
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Whitewater100,

Thank you for your quick answer! Wat i actualy want is this: Fill column Actual Status as a nieuw measure

 

THanx!