Forum Discussion
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 help me.
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.
8 Replies
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 )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!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.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.
