When To Use The CALCULATETABLE Function - DAX Function Techniques [2022 Update]

CALCULATETABLE can be a mind-bender when you're just starting out with Power BI. In this tutorial, Sam shares what he thinks are the best ways and purposes to use this function, and how to get the most out of it in Power BI.

***** Video Details *****
00:00 Introduction
04:17 Calculating new customers
06:20 Evaluating a customer set
06:51 Adding a FILTER function
08:27 Calculating lost customers
08:43 Adding the EXCEPT function

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

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial

[hamishmaxa]

Very good. Thank you.
People ask me what does power bi do. I try and explain that in simple terms it allows you to create pivot tables, that then influence (filter) cascading pivot tables to give you an intersection of attributes that you want to look at (of course, it's a whole lot more than that). Your example here is excellent! The biggest gain I see is what you mention, it gives readability and easy interpretation of the logic in the DAX code.

[cesarsaldana]

Hello Sam, the logic that you use to solve the problem helps me understand more about the use of this function.... Greetings from Mexico.

[MrMenace]

I'd like to test this but what is your formula for "Churn Time Frame Value"? I would like to recreate this to test with my dataset!