Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Get last known value

Hi all,   i'm trying to get the last know value from a table, but can't figure out the steps to do it. The goal is to have a name for each role. So if a name isn't entered in the yearmonth, it sho...
  • AlB's avatar
    5 years ago

    Anonymous 

    Not sure I understand. Do you want this in a visualor in PQ?

    Why are there two entries for Asset manager in 2021 05? I've eliminated the last one.

    Check the attached file for a possible solution

     

    Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.