Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Find last Product Rev - either Calculated Column or Measure

Hi Everyone,   I have been struggling to find a solution to finding that last time my Product Rev changed.  The goal is to have my Power BI show if the revision changed and so far all my attempts h...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 

    in your example you are showing the minimum version for the same Product/Prod Rev. but you asking for the last? Please clarify. Otherwise, to produce the same results as per the provided sample and results you may try a calculated column 

    Latest Rev Date =
    CALCULATE ( MIN ( 'Table'[Version] ), ALLEXCEPT ( 'Table', 'Table'[Product], 'Table'[Prod Rev] ) )

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi tamerj1 ,

     

    You got it perfect!  Sorry about the mix up in min and max.  Min was what I was looking for.  

     

    Thank you so much!

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 

in your example you are showing the minimum version for the same Product/Prod Rev. but you asking for the last? Please clarify. Otherwise, to produce the same results as per the provided sample and results you may try a calculated column 

Latest Rev Date =
CALCULATE ( MIN ( 'Table'[Version] ), ALLEXCEPT ( 'Table', 'Table'[Product], 'Table'[Prod Rev] ) )