Adam looks at why the LastDate DAX function is returning the wrong date within Power BI Desktop. Breaking down a twitter conversation.

Twitter thread: https://twitter.com/dhawalmehta/status/1183750809646972929

Marco’s Blog: https://www.sqlbi.com/articles/semi-additive-measures-in-dax/
Reza’s Blog: https://radacad.com/lost-customers-dax-calculation-for-power-bi

Calendar Table: https://www.youtube.com/watch?v=gyvhM5eiT0U
Reduce data model size: https://www.youtube.com/watch?v=c-ZqToc85Yc

Sample download