Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
@GoingIncognito Please try this as a "New Table"
Test73DynamicDimDate = VAR _StartDate = EDATE(TODAY(),-6) VAR _EndDate = EDATE(TODAY(),12) RETURN CALENDAR(_StartDate,_EndDate)
Proud to be a PBI 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)
Proud to be a PBI Community Champion
Thank you so much! I have to say about you that not all heros wear a cape!
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |