Forum Discussion
Help with Date intelligence
Hi team, I have created Total cases for the Current MTD , Current QTD and Current YTD. The data shows correctly However, when I create previous MTD, previous QTD and previous YTD. The data are a...
DimDate =
VAR StartDate = DATE(2020,1,1)
VAR EndDate = DATE(2030,12,31)
RETURN
ADDCOLUMNS(
CALENDAR(StartDate, EndDate),
"Year", YEAR([Date]),
"Month Number", MONTH([Date]),
"Month Name", FORMAT([Date], "MMMM"),
"Month Short", FORMAT([Date], "MMM"),
"Quarter Number", QUARTER([Date]),
"Quarter", "Q" & QUARTER([Date]),
"Year-Month", FORMAT([Date], "YYYY-MM"),
"Year-Quarter", YEAR([Date]) & "-Q" & QUARTER([Date]),
"Day Number", DAY([Date]),
"Day Name", FORMAT([Date], "DDDD"),
"Day Short", FORMAT([Date], "DDD"),
"Week Number", WEEKNUM([Date])
)
i have created the following dim date table. After that, when I join the date to lodge date, the relationship becomes inactive. Any clues to fix that?