In the head of: Marc and Dave, the Power BI cheatsheet authors

During SQL Saturday in Stockholm, i had a chance to meet Dave and Marc, the authors of the Power BI Cheat Sheet and had a chat with them. Thanks guys!
#powerbi #cheetsheet #curbal

Download the Power Bi cheatsheet here:

and here is the merch for charity:

Here you can download all the pbix files:

SUBSCRIBE to learn more about Power and Excel BI!

– Join our DAX Fridays! Series:
– Power BI dashboards for beginners:
– Power BI Tips & Tricks:
– Power Bi and Google Analytics:



Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:


Contact us:


If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

Many thanks in advance!



What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!


Linkedin ►
Twitter ► @curbalen, @ruthpozuelo
Facebook ►

View on YouTube

Understanding The CALCULATE Function – Ultimate Beginners Guide to DAX

Understanding The CALCULATE Function – (1.12) Ultimate Beginners Guide to DAX


Follow along to the beginners guide DAX tutorials by using the demo data available for download. Enjoy!

Details of what you will learn during this course
Learn – what DAX is and why you need to learn it when using Power BI
Learn – the basics of DAX calculations
Understand – formula syntax, writing comments & variables
Review – how the data model and DAX calculations work together
Learn – what the most important concept of DAX is – CONTEXT
Understand – what the CALCULATE statement does
Learn – what table functions are and when to use them
Review – time intelligence functions
Understand – how important learning DAX well is when using Power BI

Here are the specifics for the course
Learn how to;
Use DAX formula with Power BI
When and where to use DAX functions
Utilise some of the great features built into the DAX formula bar
Use the data model in combination with DAX formula
Understand the concept of CONTEXT
Use the CALCULATE statement
Create filters using table functions
Incorporate time intelligence functions in your analysis
Become a DAX master by combining patterns of DAX formula

Here I work through how important the CALCULATE function is to any advanced analysis in Power BI.

If you want to complete great work in Power BI then using CALCULATE and understand what is does is essential

***** Learning Power BI? *****

All Enterprise DNA TV Resources –

FREE COURSE – Ultimate Beginners Guide To Power BI –

FREE COURSE – Ultimate Beginners Guide To DAX –

FREE – Power BI Resources –

Learn more about Enterprise DNA –

Enterprise DNA Membership –