Hi Sir, Great explanation of DAX Functions, understandable way of teaching is very nice. Useful for self learners. Thanks a lot for giving such a valuable information.
post full videos for data modling, because if we complte visualisation(when we use which visualisation),data modeling, measure and calculate column in power bi 70% power bi is completed.
Sir, ur explanation was good and execellent but in the video you are worked one excel file same file is not available in that sharing drive link. Could you please rename the data what u mentioned in ur video so that we can refer easily. moreover, i need previous video of this. Because in this u said pls see and check the previous one then you come so pls send me the link and datasets too. It will be very helpful to me
Hiii sir, DOUBT in 01:31 You gave only 3 conditions , didnt use a condition when Filter1 NOT ISBLANK and Filter 2 ISBLANK. But in your visualization there was a correct output, can u clarify me about that? (with that included condition below:) Y&Q Filters = VAR Filter1 = SELECTEDVALUE('Orders Data'[Year]) VAR Filter2 = SELECTEDVALUE('Orders Data'[Quarter]) RETURN SWITCH( TRUE(), AND(ISBLANK(Filter1), ISBLANK(Filter2)), "Sales Metrics (All Periods)",
why did you add profit to sales in maxx function. also while applying filter furniture in DAX code certain rows are empty however when you select the filter in visual as furniture its not empty why?
post full videos for data modling, because if we complte visvalization,data modeling, measure and calculate column in power bi 70% power bi is completed.
Sir . Boolean function then total sales and cost ..you said you have to create before itself ..in which video you applied if condition for Bolean function
Hi Sir, How to add condition after aggregate and group by function. For example Count(city),group by (employee) condition filter chennai,trichy,madurai.
Concatenation of firstname and lastname with space using CONCATENATE: Employee Name = CONCATENATE(CONCATENATE(Employees[FirstName], " "), Employees[LastName])
Countx and countax -both counts the Boolean value.. *Countx* counts yes and no.... *Countax* counts the true and false.. Then what's the difference????
Romba thanks anna naa oru internship join paneruken powerbi pathe sutqhama knowledge kedaiyathu unga video pathutha task epo panetu iruken..Romba thanks anna
Hello, MAX is used to find only the Maximum value it won't support the Date column. Every DAX function has a unique purpose. I understand it seems confusing sometimes but once you start using it you will get familiar with it. Everyone had a different way of learning and teaching 👍
Great Work sir. I'm learning Power BI from your channel only. It's very helpful for me. Thank you for your efforts.
Thank you for your valuable feedback and support 👍
Clear explanation about Dax functions. Thank you so much, sir.
First comment. All in one video, I love it ❤
Thank you for your valuable feedback and support 👍❤️
Great effort really useful for learning DAX function...thank you so much bro
Glad to know it helped you 👍
Very Nice Explanation...in TAMIL....Keep Rock it....
😊 Thank you for your valuable feedback and support 👍
Hi Sir, You are too good in explaining the concepts
Thank you for your valuable feedback 💯
Hi Sir, Great explanation of DAX Functions, understandable way of teaching is very nice. Useful for self learners. Thanks a lot for giving such a valuable information.
Excellent bro 🎉🎉
Thank you for your valuable feedback and support 👍
You saved my time by clear cut explanation. Thank you so much.
Glad it helped!
Very helpful... Thanks!!!
Hi, I can't see the source file for order data in the drive. Could you plz share me the link. In the drive folder we have only employee sample data
Did u get that file ?
@@shakespearea6500I can't find the file where it is ?
post full videos for data modling, because if we complte visualisation(when we use which visualisation),data modeling, measure and calculate column in power bi 70% power bi is completed.
Thank you for your feedback.. I will do that..
Good one. Very helpful
Thank you for your feedback 🙂👍
Very Useful thank you bro
Thank you for your valuable feedback and support 🙂👍
Plz upload all data files which u mentioned
Romba nandri bro
Thank you for your valuable feedback and support 👍
Sir I followed ur channel. Ur way of teaching too gud. Can u please make a video for "Tableau" also
Hello, surely but after completing SQL😊 it may take another 3 months
Excellent 👌👍
Thank you 👍
Very useful video
Glad you liked it
Superb video clearly explained
Sir, ur explanation was good and execellent but in the video you are worked one excel file same file is not available in that sharing drive link. Could you please rename the data what u mentioned in ur video so that we can refer easily. moreover, i need previous video of this. Because in this u said pls see and check the previous one then you come so pls send me the link and datasets too. It will be very helpful to me
Hiii sir, DOUBT in 01:31
You gave only 3 conditions , didnt use a condition when Filter1 NOT ISBLANK and Filter 2 ISBLANK.
But in your visualization there was a correct output, can u clarify me about that?
(with that included condition below:)
Y&Q Filters =
VAR Filter1 = SELECTEDVALUE('Orders Data'[Year])
VAR Filter2 = SELECTEDVALUE('Orders Data'[Quarter])
RETURN
SWITCH(
TRUE(),
AND(ISBLANK(Filter1), ISBLANK(Filter2)), "Sales Metrics (All Periods)",
Hello, happy to assist. Could please specify the correct time where exactly you have doubt!
why did you add profit to sales in maxx function. also while applying filter furniture in DAX code certain rows are empty however when you select the filter in visual as furniture its not empty why?
post full videos for data modling, because if we complte visvalization,data modeling, measure and calculate column in power bi 70% power bi is completed.
Will cover data modeling..
Sir . Boolean function then total sales and cost ..you said you have to create before itself ..in which video you applied if condition for Bolean function
This is very useful information to us. And can you tell me for this 52 videos only enough to data analysis role and business analysis role right?
Certainly, this will help you to start and you have upskill based on the business requirements
Where can I find datasets to practice DAX functions? I couldn't find them in the description.
I have already given the link in the description
drive.google.com/drive/folders/1lCCKfdMWeQWrg39Fzg7wkLCU8fFnvVM7?usp=sharing
@@SanthuAnalytics9510it was not same Data set sir
Could you pls reply ..total cost how to create ...in which video you posted . I searched i didn't find it
sir is maxx is similar to maxif in excel
Hello, yes 😊
Hlo bro...primavera p6 and power bi ku connect panni videos poduveengala
Hello, thank you for your feedback. I'm planning with SQL for now and will see in the future about Primavera P6
@@SanthuAnalytics9510 tq sir...waitng for that video💥
Can you put any interview preparation video for power bi bro
Sure, I will try in the future 👍
Bro
In description that you have given the source link but that data are not you have workout in that video, please send me the correct source link. 🙏
He has seperate videos for each and every DAX function. You can find there. This video is a compilation of those videos.
Hi Sir, How to add condition after aggregate and group by function. For example Count(city),group by (employee) condition filter chennai,trichy,madurai.
you can use calculatetable along with summarize function...
how to get (Data & TBL_Employees) in source file link pls tell sir
sir kindly mention timestamps for every topics
Sure, thank you for your feedback
Share the excel file...
drive.google.com/drive/folders/1lCCKfdMWeQWrg39Fzg7wkLCU8fFnvVM7?usp=sharing
@@SanthuAnalytics9510 In the above link "DATASETS" not available which you are explaining in the video, really frustrating
Concatenation of firstname and lastname with space using CONCATENATE:
Employee Name = CONCATENATE(CONCATENATE(Employees[FirstName], " "), Employees[LastName])
Countx and countax -both counts the Boolean value.. *Countx* counts yes and no.... *Countax* counts the true and false.. Then what's the difference????
The difference was countx not allowed the blanks... But countax accepted and counts the value..
Sql ku ithe mathere vudeo pannuga
Hello 👋 Sure, I will starting from next month thank you for your feedback
Romba thanks anna naa oru internship join paneruken powerbi pathe sutqhama knowledge kedaiyathu unga video pathutha task epo panetu iruken..Romba thanks anna
Very 🎉 nice
I'm really glad that it's helping you. Please let me know if you need support on the project WhatsApp # 9481829911
Can u tell me about that internship pls?
why do we use MAXA to get the maximum date while MAX do the funtion
Sometimes your teaching makes confusion
Hello, MAX is used to find only the Maximum value it won't support the Date column. Every DAX function has a unique purpose. I understand it seems confusing sometimes but once you start using it you will get familiar with it. Everyone had a different way of learning and teaching 👍
super effort sir.