Using Variables in Power BI – A Detailed Example

How To Use Variables In DAX Power BI

In this post, I’ll show you how to use variables within your DAX formula in Power BI. Variables are a real game-changer for the formula bar in Power BI. Being able to break down your more complex formulas in steps makes setting them out much more intuitive. I keep thinking back to using VBA with

Continue reading

Using SAMEPERIODLASTYEAR To Compare The Difference Between This Year & Last Year

Using SAMEPERIODLASTYEAR To Compare the Difference Between This Year & Last Year

In this post, I run through how to use SAMEPERIODLASTYEAR, a time intelligence function, to compare results from this year with those of last year. If you want to start creating compelling reports with strong insights into information over time, then you’ve got to know how to use all the variations of time intelligence functions.

Continue reading

Enterprise DNA Learning Summit August 2019 – Final Day Wrap Up

We have reached the end of this quarter’s Learning Summit! What a fantastic event it has been. Thank you to all those who attended any session or have watched any of the replays. Always appreciate the feedback that comes in. Just to wrap up for the summit, I thought I would review some of the

Continue reading

Enterprise DNA Learning Summit August 2019 – Second Day Wrap Up

Another 2 sessions completed today with a great turnout once again. We stepped things up a level today with a detailed review of CALCULATE vs CALCULATETABLE and DAX Formula Combinations While some of the concepts might have been new to those who attended, the great thing I feel is how achievable they are for all

Continue reading

Enterprise DNA Learning Summit August 2019 – First Day Wrap Up

DAX Fundamentals in Power BI

What a great start to the Enterprise DNA Learning Summit. Today we had two sessions that dived into some beginner and intermediate development techniques that can be utilized inside of Power BI. We had a record number of live attendees of close to 350 which is a fantastic result. Every continent around the world was

Continue reading