Variable with last date selection

[Anonymous]

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 help me.

[Anonymous · Accepted solution]

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.

[Anonymous]

It works! Thank you !

[Anonymous]

Hi @Anonymous ,

Please try:

Measure = 
var _lastDate=MAXX(FILTER(ALL('Table'),[Invoic-nr.]=MAX('Table'[Invoic-nr.])),[Date])
return CALCULATE(MAX('Table'[Status]),FILTER('Table',[Date]=_lastDate))

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.

[Anonymous]

Hi Eyelyn,
Thannk you for your effort.
I have used your solution, but it does not work unfortunetly. 

Kind regards.
Walid

[Whitewater100]

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]

Hi Whitewater100,

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

THanx!

[amitchandak]

@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]

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!