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 ,

 

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

    It works! Thank you !