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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi mahoneypat Thanks! The report date column has been copied into the same column. The measure, however, returns always the latest Project date independent of the current Report date... 

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi  Anonymous 

    Could you please share your sample pbix file and your expected output, that will be a great help.

     

    Regards,

    Lin