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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi AntrikshSharma

 So the Due Date = Report date and Order Date = Project date or other way around?

What is they are in different tables? How would the line 8 Summarize look like?

AntrikshSharma's avatar
AntrikshSharma
Community Champion
6 years ago

Summarize can group by columns of mulitple tables, example:

SUMMARIZE(
    Sales,
    Sales[Order Date],
    Sales[Due Date],
    Customer[Birth Date]
)