DAX Fridays! #81: CALCULATETABLE
In todays video we are going to cover the DAX function CALCULATETABLE.
CALCULATETABLE allows you to create virtual tables that you can then filter using multiple conditions and use that table to make further calculations.
What is the difference between CALCULATETABLE and CALCULATE?
The first one returns a table, while the second one returns a value.
On an upcomming video I will cover CALCULATE vs FILTER.
Happy friday with DAX Fridays!
Link to the Power BI file: https://curbal.com/blog/glossary/calculatetable-dax
Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU
Link to DAX Fridays survey: http://bit.ly/2MMM4KK
Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
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:
https://curbal.com/product/sponsor-me
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!
https://www.amazon.com/shop/curbal
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB
#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP
Видео DAX Fridays! #81: CALCULATETABLE канала Curbal
CALCULATETABLE allows you to create virtual tables that you can then filter using multiple conditions and use that table to make further calculations.
What is the difference between CALCULATETABLE and CALCULATE?
The first one returns a table, while the second one returns a value.
On an upcomming video I will cover CALCULATE vs FILTER.
Happy friday with DAX Fridays!
Link to the Power BI file: https://curbal.com/blog/glossary/calculatetable-dax
Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU
Link to DAX Fridays survey: http://bit.ly/2MMM4KK
Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
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:
https://curbal.com/product/sponsor-me
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!
https://www.amazon.com/shop/curbal
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB
#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP
Видео DAX Fridays! #81: CALCULATETABLE канала Curbal
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![DAX Fridays! #78: When should I use FILTER() with CALCULATE?](https://i.ytimg.com/vi/ewjRItLlgG8/default.jpg)
![DAX Fridays! #77: GROUPBY, CURRENTGROUP](https://i.ytimg.com/vi/pn3pf7pcwOA/default.jpg)
![Microsoft Power BI: Deep dive into DAX evaluation context - BRK3060](https://i.ytimg.com/vi/teYwjHkCEm0/default.jpg)
![#41 Understanding relationships in Power BI Desktop](https://i.ytimg.com/vi/-4ybWQSRcOY/default.jpg)
![](https://i.ytimg.com/vi/WcYOx5Svvzk/default.jpg)
![When To Use The CALCULATABLE Function - DAX Function Techniques](https://i.ytimg.com/vi/MXfpBcwOJSw/default.jpg)
![DAX Fridays! #143: ADDCOLUMNS and SUMMARIZE | Create virtual tables](https://i.ytimg.com/vi/hoIsIsa6b4M/default.jpg)
![Using the SELECTEDVALUE function in DAX](https://i.ytimg.com/vi/Zhp1fAfN8Hw/default.jpg)
![Showing actuals and forecasts in the same chart with Power BI](https://i.ytimg.com/vi/DKgF-5QHY68/default.jpg)
![REDUCE the # of measures with Calculation Groups In Power BI](https://i.ytimg.com/vi/vlnx7QUVYME/default.jpg)
![#2 DAX Fridays! 101: Introduction to filter and row context](https://i.ytimg.com/vi/xV-KwuSDFMQ/default.jpg)
![#1 DAX Fridays! 101: The basics of the DAX Language](https://i.ytimg.com/vi/DwuAypulTLA/default.jpg)
![Secondary Table Logic Inside Of Power BI Using DAX](https://i.ytimg.com/vi/Nf55zxQf8K8/default.jpg)
![DAX Fridays #186: CALCULATE vs CALCULATETABLE](https://i.ytimg.com/vi/P4B9FbzrotM/default.jpg)
![DAX Fridays! #46: What is the difference between calculated column and measure in Power BI?](https://i.ytimg.com/vi/SmXLgEHXSGc/default.jpg)
![Power BI Full Course - Learn Power BI in 4 Hours | Power BI Tutorial for Beginners | Edureka](https://i.ytimg.com/vi/3u7MQz1EyPY/default.jpg)
![DAX Fridays! #27: RELATED vs RELATEDTABLE](https://i.ytimg.com/vi/IQ25ATvJBoM/default.jpg)
![20 tricks to finally master the Matrix visualization in Power BI!!](https://i.ytimg.com/vi/58a2rIV2nYg/default.jpg)
![Grouping & Segmenting Your Data With DAX Measure Logic - Advanced DAX](https://i.ytimg.com/vi/iH3gW_vy69o/default.jpg)
![Understanding The CALCULATE Function - (1.12) Ultimate Beginners Guide to DAX 2019](https://i.ytimg.com/vi/x29vx0Zj_7M/default.jpg)