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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

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

    Kind regards.
    Walid