Leap Year - Previous Month

Courtb86 — Thu, 21 Mar 2024 19:49:27 GMT

I have a calendar and its not showing dates from 02/29 and I feel really dumb asking this but can someone look at my code and let me know how to fix this?

Calendar =

VAR BaseCalendar =

CALENDAR("01/01/2023", "12/31/2040")

RETURN

GENERATE (

BaseCalendar,

VAR BaseDate = [Date]

VAR DayNum = WEEKDAY(BaseDate, 1)

VAR DayDate = DAY(BaseDate)

VAR WeekDate = WEEKDAY(BaseDate, 1)

VAR YearDate = YEAR(BaseDate)

VAR MonthNumber = MONTH ( BaseDate )

VAR MonthName = FORMAT ( BaseDate, "mmmm" )

VAR MonthYear = CONCATENATE(CONCATENATE(MonthName, ", "), YearDate)

VAR CurrentYear = IF( YearDate = YEAR(TODAY()), "TRUE", "FALSE")

VAR PrevMonth = IF(MonthNumber = MONTH(TODAY())-1, "TRUE", "FALSE")

VAR LatestMonth = IF(CurrentYear = "TRUE" && PrevMonth = "TRUE", "Previous Month", MonthName)

RETURN ROW (

"Day", DayDate,

"DayNum", DayNum,

"WeekDate", WeekDate,

"Year", YearDate,

"Month Number", MonthNumber,

"Month", MonthName,

"MonthYear", MonthYear,

"PreviousMonth", PrevMonth,

"CurrentYear", CurrentYear,

"Previous Month", LatestMonth

)

Re: Leap Year - Previous Month

JamesFR06 — Thu, 21 Mar 2024 19:57:00 GMT

Hello

I've tried your code on my pc and no error and last date is 31/12/2040

Re: Leap Year - Previous Month

Courtb86 — Thu, 21 Mar 2024 19:59:35 GMT

Weird because the relationships I have are not showing 02/29/2024 that I know has data within them.

Re: Leap Year - Previous Month

JamesFR06 — Thu, 21 Mar 2024 20:04:27 GMT

uld be inside datas or not. WHen you asked to genrate to this date to this one, for me he is not taking care of datas

topic Re: Leap Year - Previous Month in DAX Commands and Tips

Leap Year - Previous Month

Re: Leap Year - Previous Month

Re: Leap Year - Previous Month

Re: Leap Year - Previous Month