Recently I had to write a DAX formula containing a LASTDATE within the logical condition of a FILTER: I found that its behavior was not the one I expected and I further investigated. At the end, I wrote my findings in this article on SQLBI, which can be applied to any Time Intelligence function with a <dates> argument. The key ...

I recently joined Chris Webb, Jen Stirrup and Alberto Ferrari as PASS Data Warehouse and Business Intelligence Virtual Chapter for Europe. We will increase the number of virtual sessions delivered in a comfortable European time zone and we are looking for speakers interested in sharing their knowledge in data warehouse and business intelligence ...