Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Return values for the last date available

Hi everyone,   I am making a report with the following tables:   ProjectList Project ID Project name Project Owner 1 Project X John Doe 2  Project Y Jane Doe   And   Stat...
need
Need Help
Need Help DAX
Need Help DAX measure
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, unfortunately it does not work for meand it even seems to return the first registered values, not the last ones...

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous pbix is attached. Please post your pbix if it does not help. I will take a look.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, yours works indeed. I took out the sensitive data out of mine and replaced with dummy data. I tried to keep it as original as possible so some of the column names are different but its the same principle. I am putting in a wetransfer link as I cannot upload files in these posts yet : https://we.tl/t-FevGPdVk3Y

    • VahidDM's avatar
      VahidDM
      Icon for Super User rankSuper User
      4 years ago

      HI Anonymous 

       

      Download this file: https://gofile.io/d/A1SLih

       

      If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
      Appreciate your Kudos!!
      LinkedIn:       www.linkedin.com/in/vahid-dm/