Forum Discussion

THEG72's avatar
THEG72
Helper V
9 years ago

Project Month Number

Just trying to work out the best way to add a project month number for reporting.   Currently, i have 4 projects in my accounting file.   They all have different project start and end dates.   ...
Need Help
Show and Tell
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

A measure like this might work :

 

 

Current Project Month = DATEDIFF(
				MIN(Projects[Start Date]),
				NOW(),
				MONTH
			)

This measure is based on a simple table as below called [Projects].  The measure will always show the current month number based on the startdate of the project.