[[ 1 HOUR ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - Full Course by Satyajit

[[ 1 HOUR ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - Full Course by Satyajit
Subscribe our KZbin Channel and press the bell icon to get regular updates👇: bit.ly/3tt2eNY
🔴 Code: github.com/pik1989/PBI-DAX
(Power BI DAX)
- Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI, Analysis Services, and Power Pivot in Excel data models.
In this video, we will be learning all the important DAX functions in just under 1.5 hours
Join our Telegram Channel For Exclusive Data Science Resources👍 :
bit.ly/3FzObsk
Check Out Our Other Helpful Videos:😍
➮ Data Analyst vs Data Scientist vs Data Engineer - Roles || Responsibilities & Skills
bit.ly/3qsg2pL
➮Live Implementation of End To End Machine Learning Project With Deployment | Customer Churn
bit.ly/3FqPQjF
➮ Build your own Alexa in 30 minutes using Python | NLP | Data Science
bit.ly/3FFBWdP
…………………………………………………………………..
Follow us on: ✌️
FACEBOOK: bit.ly/3I89SB4
INSTAGRAM: bit.ly/3tsVpf9
LINKEDIN: bit.ly/3fmwmCa
Hello Friends , I am Satyajit Pattnaik, In my channel you will find every information about Data Science & Analytics which will help you become an expert Data Scientist or a Data Analyst along with which you would enjoy a loads of interesting and useful projects.
More & more great stuffs coming soon, keep supporting & learning 🎓
THANKS FOR WATCHING 😊
#powerbidax #powerbi #dax #satyajitpattnaik

[@saeelsalvi1739]

00:03 DAX is about data analysis expressions and using functions like sum, average, min, max, count, count rows, calculate, and filter. 02:23 Differentiating between measures and calculated columns 06:59 Understanding the difference between calculated column and measure 09:13 Power BI DAX functions make data manipulation simple 13:49 DAX is good at two things: aggregations and filtering. 16:14 Understanding and validating DAX measure assignments 20:32 Creating measures for minimum and maximum salary using DAX functions 22:52 Understanding different DAX functions 26:53 Power BI DAX functions for date and time analysis 29:15 Creating calculated tables and adding/subtracting dates in Power BI using DAX 33:15 Creating relationships between tables and adding new tables in Power BI 35:23 Creating a calendar table in Power BI for a specific date range and sorting the data based on month numbers. 39:24 Creating filter context in SQL and Power BI using calculate keywords. 41:29 Creating measures and filter context in Power BI DAX 45:47 Filtering a table using different methods 47:57 Understanding if-else and nested if blocks 52:20 Creating conditional columns in Power BI using DAX 54:38 Time intelligence functions help manipulate data using time periods. 58:47 Creating and understanding total year-to-date (YTD) in Power BI DAX 1:00:54 Explanation of Year to Date (YTD) concept 1:04:59 Using DAX measures for time intelligence in Power BI 1:07:00 Time intelligence functions for comparing previous and current values. 1:11:20 Reducing columns to optimize memory consumption. 1:13:25 Creating DAX expression for calculating total 1:18:12 Understanding the difference between average and average a in Power BI DAX 1:20:22 Using the x function saves memory and CPU utilization Crafted by Merlin AI.

[@ujjwaltarway1438]

Thank you so much for the video. I am preparing for Power BI interview a guide would be helpful like what all we need to know means the topics and scenario. This was great video

[@shubhammalode4733]

Awesome way of teaching DAX .😊 We are waiting for your next video

[@juja2819]

Awesome! I like that you talk about and show examples from SQL and Python. Hope you keep it in your videos :)

[@PawanJaiwar-kg1lf]

way of teaching amazing.tq sir

[@anjalikesarwani4970]

Thanks for your dax video, Its very easy to understand.

[@ajityadav-db7qq]

I have understood these concepts earlier but somewhere I was lacking to learn it, now it's more clear bcz ur teaching style gives clarity on each topics. In today's class, I understood the implementation and application - why, where & when to use those concepts. Thanks a lot for this session... Love you❤🤟 God bless you

[@SatyajitPattnaik]

Thanks a lot for this comment 🔥🔥

[@praveenkumarrai101]

Amazing video for beginers

[@shachendradubey7978]

It is Awesome. Waiting for your Advance and complex DAX calculation video.

[@vishalbhattacharya690]

Very informative content, Thanks for the wonderful session!

[@SatyajitPattnaik]

I am glad you liked!! 🔥

[@anandramavarapu-pe7zv]

super nice explanation.

[@DishuMittal05]

Very informative video👏❤

[@shailshah9967]

interesting n informative session. Thankyou sir...learnt many many things today in BI

[@SatyajitPattnaik]

I am glad you liked 🔥

[@saidarao1750]

Thae way of teaching is very impressive and reliable. could plz provide interview quation and answers as a pdf plz.

[@priyankashriramoji]

Cannot thank you enough for making such a crisp video on DAX🙏

[@SatyajitPattnaik]

😍😍

[@jaypandey4101]

Thank you sir for uploading it, it's really helpful.

[@SatyajitPattnaik]

Welcome

[@ronylpatil]

I was looking for same and finally you uploded it. Really Amazing Video. Keep Growing🙂

[@SatyajitPattnaik]

😎😎

[@an_piya4358]

53:52 - Time Intelligence 1:08:12 - X and nonX

[@shraddhaverma4111]

Thank you sir !!!

[@SatyajitPattnaik]

Welcome 🔥🔥

[@Gareeb_]

Thanks 😊👍

[@SatyajitPattnaik]

Welcome 😊

[@soumighosh6726]

Very informative video, but while I was trying to practice ,in report view col name are coming as 'Sum of estimated salary' for all whole numbers and decimal numbers.

[@divasukinkoblenz]

Thank you for this video. It was really helpful. Can you also make a video on data modeling in power bi?

[@SatyajitPattnaik]

Yes can be done

[@adistrail]

It helps me to understand dax...one feedback please dont use bgm it distracts

[@shikharsaxena8984]

Very informative and useful video sir, appreciate your work 👏👏, please if you can make a detailed video on power query in PBI also, it will be great, thank you sir

[@SatyajitPattnaik]

I already have a detailed end to end video, search power bi Satyajit, you will get it..

[@shikharsaxena8984]

@@SatyajitPattnaik yes sir found the video 🙂

[@roronoazoro-518]

Hello Sir, Could you also make a video on how to prepare for Pl-300 certification for Power BI beginners?

[@PraveenKumar-ic1to]

U better become pro at powerbi that's only how u can crack it.otherwise there is no chance of cracking it

[@jaspreetsinghbrar2055]

Awesome video just one feedback some places content was hiding by your picture.

[@eraofpoojasagar]

If I am Nurvous about Job then I saw your videos. Then I get confidence to start study

[@SatyajitPattnaik]

Such a huge compliment 🙏

[@roshankumar-br7of]

super video....if you have any full course ob power bi

[@SatyajitPattnaik]

I have most of the videos on my channel, for a more structured learning you can enroll my course , it costs INR 999/-

[@arunavamukherjee7549]

Very nice. Do you have example file to download? thanks

[@piyushpathak7311]

Sir pls made same video for SQL for data analyst means from beginning to advanced level

[@SatyajitPattnaik]

There's already a SQL video, check my playlists.

[@madhuparnadebnath9061]

Plzz send the raw data set .... I want to practice...

[@venkatexplorermetturdam]

bro superb i am also interested in teaching , can u guide how your recording and which softwer are using and editing can i know and mic part can u say just for growing my channel im asking

[@gauthama4092]

Hi Satyajit, Thanks for this wonderful session. I have one doubt. At 51:45 , when you are calculating age bins, there is a row which has age 103, ideally the age bin should be "greater than 60". Why does it show 20-40?

[@SatyajitPattnaik]

Not clearly visible, can you try the same and let me know if you are able to get the same problem or not

[@gauthama4092]

@@SatyajitPattnaik Hi Satyajit, I'm still getting the same. Also, at 50:29 when you sorted Age in descending order, first record shows a person with age 706 which is not possible. When I opened the csv file in excel, max age I can find is 92. Not sure why in power BI it shows something weird. Am I missing something?

[@SatyajitPattnaik]

@@gauthama4092 Age might be getting summarized, click on the Viz, go to the fields, and click on Age and see if it is in Don't summarize mode or something else, must be a minor problem

[@gauthama4092]

@@SatyajitPattnaik Sure. BTW this is an excellent tutorial. Thank you for this great video.

[@madhuparnadebnath9061]

Could you provide the raw dataset what are you using in this video??

[@edchris658]

Background music is annoying. Content is good.

[@priyaselvaraj4070]

Can you help me with the link to download datasets

[@himanshuvarshney4670]

Pls provide the data set link which you used in this vedio

[@JahannaviSingh-wo7nz]

could you please provide the data for practice

[@user-wf5tc4qf6t]

kindly provide the Dataset Sir

[@shrihaan_shaurya]

I don't have drill through option in power bi.I tried many times but failed.what to do please tell me

[@amanahmed6057]

at 26:36 why you wrote AirPassengers[Month],Today(),year why not AirPassengers[Year],Today(),year

[@vismitasai2521]

kindly provide us the dataset

[@Akashavani7]

Is it enough to get a job ? Or have to learn something?

[@SatyajitPattnaik]

It's enough

[@lokeshbatra3500]

i am niy able to set quality of the video.. can somebody pls help to set it upto 1080p or is it not avaiable for that format.

[@SatyajitPattnaik]

click on settings button, quality and advanced

[@AmitKumar-ft9go]

At vedio duration - 29.56 For DateAdd why there is Blank rows showing and what do u mean by the dates are not available? I mean how is this possible that dates are not available? Will be glad if u clear my doubts.

[@AmitKumar-ft9go]

Kindly reply something

[@SatyajitPattnaik]

@@AmitKumar-ft9go oh sorry, I thought I answered. DateAdd basically will show those values that are in the range of the original Date column, infact that's how all Time Intelligence functions work.

[@SatyajitPattnaik]

Just imaging a scenario, if X is derived from Y, how can X have new values that are present in Y

[@KiranGunda-ph7df]

Increase ur voice... Else shutdown the background noise

[@priyankaraut4726]

Background Music

[@pashaji5904]

Screen is not clear, do the needful

[@vijayarana2087]

background sound is not good

[@SatyajitPattnaik]

Turn on the cc’s

[@optiontrading5951]

keep shut down background music

[@Fantikky]

please dont put any music in your videos

[@SatyajitPattnaik]

This is a 2 year old video, I stopped putting music on my recent videos 😀

[@famjam954]

Not clear

[@anjalitherkar7439]

Its not that crisp and clear... and I do not understand why you are using PDF to explain the concepts.

[@SatyajitPattnaik]

Did you go through the entire video? I hardly used the presentation for less than 5% of the entire time to show the DAX functions and then explained it on Power BI, pls go through the videos before commenting 😀

[@shitluna50kgonedogegogogo87]

there is no need for that background music. already your microphone is not that good

[@SatyajitPattnaik]

Apologies

[@madhuparnadebnath9061]

Plzz send the raw data set .... I want to practice...

[@SatyajitPattnaik]

Check description