Forum Discussion
Solved
Simple Calculated Column?
Hi folks, I've got a basic Date table with a DIMDate[Date] primary key. I'm trying to create a boolean calculated column that determines if the [Date] is part of a completed school year. N...
aha, try this
School Year Completed =VAR YearCheck = YEAR(DIMDate[Date])VAR MonthCheck = MONTH(DIMDate[Date])VAR Result =IF (YEAR(DIMDate[Date]) >= YEAR(Today())&&MONTH(DIMDate[Date]) >= 9,FALSE,TRUE)RETURN Result
aha, try this
School Year Completed =
VAR YearCheck = YEAR(DIMDate[Date])
VAR MonthCheck = MONTH(DIMDate[Date])
VAR Result =
IF (
YEAR(DIMDate[Date]) >= YEAR(Today())
&&MONTH(DIMDate[Date]) >= 9,
FALSE,
TRUE
)
RETURN Result
Boom! The converse logic works! Thanks much.