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
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous  you can use a measure like this

Measure =
CALCULATE (
    MAX ( StatusUpdates[Update] ),
    FILTER (
        VALUES ( StatusUpdates ),
        StatusUpdates[Date]
            = CALCULATE (
                MAX ( StatusUpdates[Date] ),
                ALLEXCEPT ( ProjectList, ProjectList[Project ID] )
            )
    )
)

 

 

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/