Forum Discussion
GoingIncognito
Advocate III
Advocate IIIDynamic or relative calendar
This must be a silly question, but as I am new to DAX I've to ask:
I would like to do calendar that shows dates half a year back AND one year onwards from today? And also use it as either a filter or slicer? How do I manage this?
Thank you so much!
GoingIncognito Please try this as a "New Table"
Test73DynamicDimDate = VAR _StartDate = EDATE(TODAY(),-6) VAR _EndDate = EDATE(TODAY(),12) RETURN CALENDAR(_StartDate,_EndDate)
2 Replies
- PattemManohar
Community Champion
GoingIncognito Please try this as a "New Table"
Test73DynamicDimDate = VAR _StartDate = EDATE(TODAY(),-6) VAR _EndDate = EDATE(TODAY(),12) RETURN CALENDAR(_StartDate,_EndDate)
- GoingIncognito
Thank you so much! I have to say about you that not all heros wear a cape!
