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!
Go to Solution.
@GoingIncognito Please try this as a "New Table"
VAR _StartDate = EDATE(TODAY(),-6)
VAR _EndDate = EDATE(TODAY(),12)
Proud to be a Datanaut !
Thank you so much! I have to say about you that not all heros wear a cape!
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.