Forum Discussion
Comparing different schedules using a generic month - RankX missing months? Better approach?
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)
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)
Thanks nhoward. I hadn't considered that approach and it's useful for another problem I was having too! Much appreciated.