Forum Discussion
Calculated Column function to Categorise Dates for an abnormal date period
I dont think this should be too difficult... essentially, I've got a list of projects with associated completion dates in one column and I want to add a calculated column which basically states the a...
Hi Anonymous
try this
NEwColumn = IF ( MONTH ( TableName[Completion_Date] ) < 9, YEAR ( TableName[Completion_Date] ) - 1, YEAR ( TableName[Completion_Date] ) )Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Helpful. Thanks