Hi, i have a lot of projects that run over 1 or more years. And to make comparison in what period of a project duration costs are made, i want to have the period visible of a projects duration.
I searched lot of stuff on internet, and found some answers with datediff dax function, but couldnt solve it .
So lets say i have 2 projects. One starts in jan 2022 and ends in june 2023. Its now december 2022 so jan is month 1 of the project, and today is month 12 of the project duration.
2nd project starts in june 2022 and ends in feb 2023, so start date is month/period 1 , december is month 7 etc.
How do i get this information in my tables? Do i need to add a column in query editor with some dax? Or do i need to create a new measure?
I already added a measure to determine the duration of a project in months with
"duration = (today() - projecttable[startdate]) / 30"
which work as it shows currently 14th month for project started in june 2021.