Forum Discussion
Justas4478
Post Prodigy
Post ProdigyCalendar date column for specific start - end date
Hi, I have calendar table and date column that is between 2023- 2025 and it automaticly changes based on earliest and latest dates in the data. I want to create another column in my calendar table t...
let
// Your existing steps here
PreviousStep = ... , // Placeholder for your existing step
// Get current year
CurrentYear = Date.Year(Date.From(DateTime.LocalNow())),
// Define the start and end dates for the custom date range
StartDate = #date(CurrentYear, 6, 1), // 1st June of the current year
EndDate = #date(CurrentYear + 1, 5, 31), // 31st May of the next year
// Add custom column for the date range check
CustomColumn = Table.AddColumn(
PreviousStep,
"CustomDateRange",
each if [Date] >= StartDate and [Date] <= EndDate then [Date] else null
)
in
CustomColumn
Bibiano_Geraldo
Super User
Super UserHi,
Create a new column in your calendar table and past the following DAX.
Note: Make sure to change column and table name to your owns.
If this answer satisfy your question, please mark it as soluction.
Column =
VAR CurrentYear = YEAR(TODAY())
VAR vStart = DATE(CurrentYear , 6 , 1)
VAR vEnd = DATE(CurrentYear + 1 , 5 , 31)
RETURN
IF(
'Calendar'[Date] >= vStart && 'Calendar'[Date] <= vEnd,
'Calendar'[Date] ,
BLANK()
)