Description: Traveling Light, Fast, and Easy: DAX Without Time Intelligence Functions
Have you ever had any of these problems with DAX Time Intelligence (TI) functions?

🔸 Overlapping, confusing functions that don't produce the results you expect them to?
🔸 Calculations that break when you move to weekly granularity, fiscal periods, or custom periods (e.g., semesters, trimesters, etc.)
🔸 Inability to work with custom calendars such as 4-4-5
🔸 Measure code that is difficult to understand and/or debug
🔸 TI measures that work, but perform slowly

There is a MUCH better way. I haven't used ANY of the DAX time intelligence functions in over two years, yet my DAX using this approach is simple and intuitive, straightforward to debug, runs fast, and easily handles any fiscal/custom/nonstandard time period or calendar.

I will walk through exactly how this approach works, and I expect by the end of the presentation you will have sufficient info and understanding to implement it in your reports as well.

You might be thinking - "this sounds great, but my organization requires that I use their date table which can't be modified". No problem - I will demonstrate how this approach can be implemented using either a custom date table OR entirely within measures.

So, what do you have to lose? (other than three dozen janky black-box functions...)

At the end of the Meetup we'll have a Raffle with prizes offered by Enterprise DNA: 1 year FREE Membership Licenses on EDNA Platform for one lucky winner from the Live attendees

Speaker:
Brian has worked across the data field for 34 years in a mix of hands-on analytic roles and executive/senior management positions.

Since 2019, he has focused primarily on Power BI, first as the PM on his agency's first large-scale implementation of Power BI, and then as the Enterprise DNA Chief Content Officer.

He is now focused on writing about data - working on co-authoring his first book, blog, and nightly posts on LinkedIn, with nearly 9 million annual views.

Brian lives in Washington, DC with his wife Sue and two charming, but ill-behaved cats who often can be seen and heard interrupting his Power BI videos.

Blog: Coming soon!
Socials : LinkedIn: https://www.linkedin.com/in/brianjuliusdc
YouTube: https://www.youtube.com/@EnterpriseDNA