Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filtering dates in two date columns

Hi, I can't get my head around filtering of date columns. I have two columns - Report date and Project date.  When I choose a Report date (say 04.07), I would like to see the latest Project date in ...
Need Help
mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Are the Report Date and Project Date columns in the same table?  In any case, here is an expression you can try

 

Latest Project Date =
VAR __thisreportdate =
    SELECTEDVALUE ( Table[ReportDate] )
RETURN
    CALCULATE (
        MAX ( Table[ProjectDate] ),
        ALL ( Table[ReportDate] ),
        Table[ReportDate] <= __thisreportdate
    )

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat