Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
Tips and Tricks
  • AlB's avatar
    AlB
    3 years ago

    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.

     

AlB's avatar
AlB
Community Champion
3 years ago

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.