Forum Discussion
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 ...
Maybe try something like this:
Measure =
VAR LastVisibleDate =
MAX ( Sales[Due Date] )
VAR Result =
CALCULATE (
MAX ( Sales[Order Date] ),
FILTER (
SUMMARIZE ( Sales, Sales[Order Date], Sales[Due Date] ),
Sales[Order Date] <= LastVisibleDate
)
)
RETURN
ResultSo 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?
Summarize can group by columns of mulitple tables, example:
SUMMARIZE( Sales, Sales[Order Date], Sales[Due Date], Customer[Birth Date] )