The DATEADD function is by far my go to time intelligence function in DAX at the moment. Mainly because of it’s immense versatility to generate time comparisons over a range of different time frames. This detailed video will go through all the various aspects of how to set up time comparison analysis with this function.
We’ve recently completed a rebrand of Enterprise DNA’s youtube channel to Enterprise DNA TV. This is an exciting development from my perspective and I see it as a great vehicle to get the message out and also to reach people all across the world as Power BI adoption grows exponentially. There’s a few platforms to get
Latest post on the Power BI community site was recently released. Navigate there via the below link. http://community.powerbi.com/t5/Community-Blog/bg-p/community_blog Also, the most recent webinar in our series was dedicated to running through the numerous techniques used to develop this solution. You can view it at our youtube channel. https://www.youtube.com/watch?v=szmJPP0Wqr0 If you would like to use the
Breaking down the way DAX works The DAX engine is a complex beast. How it stores the data, then works through it to calculate answers is quite spectacular. Let’s step back for a moment though and try to distill it down into some simple steps, that we can memorise and intuitively start iterating over when