No video

CALCULATE vs CALCULATETABLE / What's the difference? // Beginners Guide to Power BI in 2021

  Рет қаралды 12,498

Fernan

Fernan

Күн бұрын

In this video I go through the main difference between the CALCULATE and CALCULATETABLE functions in Power BI. We go through a brief explanation, as well as a quick demo to explain it better.
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of KZfaq.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.micros...
#PowerBI #DataAnalytics #BusinessIntelligence

Пікірлер: 19
@goldwhispers
@goldwhispers 2 жыл бұрын
I have watched quite a few of your videos and just want to say that when i want to remind myself on a topic i rate your videos up there with some of the top expert youtube ones!
@ChrisSmithFW
@ChrisSmithFW 2 жыл бұрын
Nicely done. Easy to understand. Thank you very much.
@SolutionsAbroad
@SolutionsAbroad 2 жыл бұрын
Glad it was helpful!
@ameyraj4947
@ameyraj4947 3 жыл бұрын
Well explained. Thanks One suggestion the background music keeps distracting from what you are explaining can you please exclude in your future videos when you start explaining. Rest video is very informative & well explained
@SolutionsAbroad
@SolutionsAbroad 3 жыл бұрын
a very big thanks for your feedback Amey, it really is much appreciated! I do have an issue with the music sometimes they are too loud and distracting, but at the same time I include them to fill in the white noise of my computer in the background. thanks for watching!
@williamarthur4801
@williamarthur4801 2 жыл бұрын
Thank you, that's all I wanted to know.
@salvi2606
@salvi2606 2 жыл бұрын
You explained this well.. Thank you so much..
@sameerkale7282
@sameerkale7282 2 жыл бұрын
Please make a video on an end to end project of DAX where important functions are used.
@PiyushKumar-tv6dr
@PiyushKumar-tv6dr 5 ай бұрын
Hi fernan!! Can I use COUNTROWS instead of COUNTX to achieve the same Objective?
@EyiBillion
@EyiBillion 3 жыл бұрын
Brilliant! Thanks
@SolutionsAbroad
@SolutionsAbroad 3 жыл бұрын
You're welcome!
@erinfield1943
@erinfield1943 5 ай бұрын
3:37- But what if you want that table to populate within the other table? Like I want those extra lines to appear in the table in which I'm writing the CALCULATETABLE function.
@baneledludlu7983
@baneledludlu7983 Жыл бұрын
Great Vedios Fernan
@chaytanya2293
@chaytanya2293 2 жыл бұрын
How CALCULATE function is different from COUNTX ? I can use filter context in COUNTX also.
@user-oy3rt1rr4l
@user-oy3rt1rr4l 2 жыл бұрын
how did you do it can you share with me , thank you
@SolutionsAbroad
@SolutionsAbroad 2 жыл бұрын
If you need the file, you can find it here: ko-fi.com/s/026641aefa
@ashishmohan4707
@ashishmohan4707 3 жыл бұрын
Hi Hope you are doing fine. very useful video and very practical need everyone for every project ......very big thanks to share with us. If it can possible can you plzz provide us excel data file which you used. Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
@SolutionsAbroad
@SolutionsAbroad 3 жыл бұрын
Hi, you're very welcome, glad my videos help! I generated the sample data using an online website, mockaroo, but if you want to exact file that i used for this video, here's a download link ko-fi.com/s/026641aefa
@cesarsaldana3429
@cesarsaldana3429 Жыл бұрын
This is a rubbish example, I expected something more, because you are implying that it works like the FIlter function and it is not.
wow so cute 🥰
00:20
dednahype
Рет қаралды 30 МЛН
나랑 아빠가 아이스크림 먹을 때
00:15
진영민yeongmin
Рет қаралды 2,7 МЛН
PEDRO PEDRO INSIDEOUT
00:10
MOOMOO STUDIO [무무 스튜디오]
Рет қаралды 18 МЛН
When To Use The CALCULATABLE Function - DAX Function Techniques
10:49
Enterprise DNA
Рет қаралды 59 М.
CALCULATE, CALCULATETABLE - DAX Guide
9:55
SQLBI
Рет қаралды 54 М.
Budget Forecasting in Power BI using Linear Regression: Manager's Guide
12:25
The Introverted Manager Show
Рет қаралды 7 М.
All Vs AllSelected Vs AllExcept | Power BI Dax Tutorial
9:53
PowerBI Zone
Рет қаралды 35 М.
wow so cute 🥰
00:20
dednahype
Рет қаралды 30 МЛН