Forum Discussion
Solved
Filter Sales by a date
Hi, I am looking to show sales information for employees three months after they have started. I have the start date in a table and have created a measure for the 3 month date or x month date: ...
Awesome, Thanks Yggdrasill
I made a couple of changes and seems to give the correct result. Two references to the sales table and the other two are to the employee table.
3 month revenue =
CALCULATE(sum(Sales[Amount]),
DATESBETWEEN(
Sales[Date],
FIRSTDATE(Employee[Start Date]),
eomonth(FIRSTDATE(Employee[Start Date]),2)
)
)Thanks
Nick
Hi,
It is difficult to help unless one sees the relatioships and the different tables. Share the link from where i can download your workbook.