topic Re: Variable with last date selection in DAX Commands and Tips

Variable with last date selection

Anonymous — Tue, 08 Feb 2022 15:25:09 GMT

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.

Re: Variable with last date selection

amitchandak — Tue, 08 Feb 2022 17:01:38 GMT

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 )

Re: Variable with last date selection

Whitewater100 — Tue, 08 Feb 2022 18:07:46 GMT

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!

Re: Variable with last date selection

Anonymous — Wed, 09 Feb 2022 06:14:00 GMT

Hi Whitewater100,

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

THanx!

Re: Variable with last date selection

Anonymous — Wed, 09 Feb 2022 06:15:17 GMT

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!

Re: Variable with last date selection

Anonymous — Fri, 11 Feb 2022 04:00:11 GMT

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.

Re: Variable with last date selection

Anonymous — Fri, 11 Feb 2022 06:38:21 GMT

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

Kind regards.
Walid

Re: Variable with last date selection

Anonymous — Fri, 11 Feb 2022 07:40:54 GMT

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.

Re: Variable with last date selection

Anonymous — Fri, 11 Feb 2022 09:50:51 GMT

It works! Thank you !