Earlier this week I posted a challenge for creating a dynamic date filter using DAX. If you want to see the challenge first and see if you can solve it, check out that post first. If you just want to see how it’s done, read on… The Challenge Based on the Date field of […]
DAX
Power BI Report Challenge – Last Activity Date
This week I’m doing something a little bit different. I wanted to post a challenge that I think could apply to many business scenarios, and see the different approaches that people might take to get to the same solution. The challenge is the following: Based on Date field of when a Client last had an […]
Using DATEADD() and other Date Tips for Filtering Data in Power BI
While working with Dates in DAX, you may have come across an interesting behavior when working with the DATEADD() function. If have used this function in SQL, you have a good idea of how the function works and the parameters you pass to it in order to shift a date forward or backwards. However, this […]