Forum Discussion
Cymbolz
Helper III
Helper IIIUnderstanding DATESYTD, DATESBETWEEN and similar functions
I am trying to understand what is happening beneath the surface with functions like DATESYTD and DATESBETWEEN. The scenario: A measure [Total] A calendar table Calendar with columns Date, Year...
The reason is explained in this article: https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/
CymbolzHelper III
Helper IIIGiving this a slight bump. Anyone?
CymbolzHelper III
Helper IIImarcorusso time for the super heros of DAX to have an input? :)
- marcorusso
Most Valuable Professional
The reason is explained in this article: https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/
- Cymbolz
Thank you marcorusso, hit the nail on the head (again!).
Mid-way through the article I was saying to myself "but it works irrespective of Mark as Date table" as that was part of my testing. Only a couple of paragraphs later did I read about when the Date column is the key in the relationship.
My life feels much more complete now :smileyvery-happy: