Forum Discussion
Solved
Comparing different schedules using a generic month - RankX missing months? Better approach?
Hi all, I am trying to compare multiple projects to see when (and how frequently) certain items are occurring during the course of a project. One project may have started in 2017, another may...
Hi jameschung ,
It sounds like you need to know how many months there are between the start date of a project and the data of a transactions/event.
The DAX function DATEDIFF should be able to help.
the sample data didn't indicate what your data model is, so i have to make some assumptions. I assume you have a project table, which has a column for start date. then you have a transactions table. You might be able to add a column to the transactions table to show how many months since start date this event happened. Use your lookup to add a column for the start date, then you can use datediff to get the month number of the project.
Month of Project = DATADIFF('Data'[Start Date],'Data'[Recieved Date],Month)
