Power BI Advanced Tutorial

[@Sarfraz-r3e]

It's one of the best Power BI training I ever attended, I have done the first five modules and is on 6th module. My sincere greetings to the instructor.

[@LearnitTraining]

Thanks for sharing!

[@unpatel1]

Finished the first 3 tutorials. Excellent teaching style. Detailed explanations but still very simple. I would recommend this series to anyone who wants to get into Power BI. This series should be the first one before anyone decides to go to the next stage of other Power BI project available on the web. I am using the Desktop Free license and I was under impression that Power BI Service is free for individual learner but it is not free! When I tried to create an account for the Service, I was asked a corporate e-mail address which I do not have and it did not accept my personal Yahoo e-mail address. In contrast, Tableau free version comes with a free cloud account where I can publish my visualizations.

[@LearnitTraining]

Hi Umeash! Thank you so much for the kind words! We are working on getting some Tableau videos created as well!

[@Wandersong13]

the same thing happened to me.. how did u sign it to the Power BI service

[@TheBOOSTEDO]

45:43 I paused and tried to write the _End of Quarter_ function and ended up with *End of Quarter = "Q"&QUARTER(ENDOFQUARTER(Orders[Order Date]))* which displayed _Q1, Q2, Q3..._ went back to the lesson and this wasn't done but I felt so good that I understood what I was doing on my own... Thank You so much for this course...😊

[@AhmedGamal-mi1ns]

I've finshed the third video right now. This channel became my second home. Thanks learnit.

[@LearnitTraining]

You are welcome! Thank you so much for watching!

[@aperxmim]

I swear Trish everytime you teach a course, you make it is so easy to learn these topics that I can have 1st graders learn this stuff and they will do a better job at work than many adults. Seriously!!😊😇😊😇

[@LearnitTraining]

Thank you for the kind words! We are glad you are learning so much from us!

[@zahoorsarbandi2982]

Excellent Course.. An essential course for every Power BI learner.👌👍👏 . The hardworking of the instructor is much appreciable.

[@LearnitTraining]

Thank for the kind words Zahoor! We appreciate it!

[@mariamuneeb8986]

No doubt your teaching style is really amazing and easily understandable Appreciate-able

[@LearnitTraining]

Thanks a ton!

[@NunoCabralGoat]

Around the 26 minute mark, for anyone wondering why the "small multiples" box isn't showing, you have to enable it in the options menu. File > Options and settings > Options > Preview features > check the "small multiples" box > restart power BI to apply changes. Hope this helps anyone who is facing the same issue I was. I spent way too much time trying to figure this out

[@ChrisSD-we1lk]

Excellent traning on Power BI. Amazing teacher. Very detailed and rightly paced. Thank you !

[@LearnitTraining]

You're very welcome!

[@osoriomatucurane9511]

Awesome, concise and crystal clear! Building Date table, is absolutely amazing. In addtion to year, quarter, month, I went on extracting the "day of week as number", weekday([date]), "week day as text", format([date], "ddd"), just the same logic with excel date time and text functions!

[@LearnitTraining]

Glad it was helpful!

[@chaolimeng8926]

It’s a very powerful , clear teaching lesson, best of KZbin channel, you guys help lots of people!

[@LearnitTraining]

Thank you! 😃

[@nasreenbanu2245]

THANKS FOR YOUR FREE COURSE WHICH IS WORTH THAN PAID COURSE.YOUR TEACHING STYLE IS OUTSTANDING.HATS OFF MAM......YOU MADE THE COURSE EASIER TO UNDERSTAND...

[@LearnitTraining]

You are very welcome!

[@nasrudeenmuhyideen3754]

I am Amazed by your great Selfless Effort. You inspire me a lot on this Subject since i stumbled on this tutorial Trish Conner-Cato. You are highly appreciated. Bless up🙏👍

[@LearnitTraining]

Thank you for the kind words!

[@nasrudeenmuhyideen3754]

You're welcome ma'am.

[@BarishaRichard]

Hi Trish, Thank you for this series of videos. They are very helpful and very detail.

[@LearnitTraining]

You are so welcome!

[@mohammedabdalkadir2237]

It's really amazing, I am not a native English speaker, however, I was able to understand everything because of your simple language.

[@LearnitTraining]

You are welcome!

[@busyhaunting2897]

Shouout to Trish Conner-Cato. Thank you for the detailed explanation and articulation, you are a true expert.

[@LearnitTraining]

Thanks for the kind words!

[@paulayamah]

@Learnit Training. It's a great tutorial, but next time, zoom in to increase the font size and sharpen the focus for better display

[@LearnitTraining]

Noted!

[@RizwanSiddiqui-p5z]

I am Speechless how can she give so much valuable info i am delighted to share that i have just completed first two vidoes i am stunned right now I appreciated the effort that you put into the video Thank you 🙂

[@LearnitTraining]

Wow, thank you!

[@lifeisgreat11]

Excellent tutorial and the very good communication by the tutor. I would suggest you to zoom in or enlarge the formula bar, sometimes the code you write at the formula bar looks to small - I have covered all sections and reviewing this now but my suggestions regards all parts.

[@LearnitTraining]

Thank you for the tip!

[@DataSciencefortheLazy]

Thanks for the comprehensive documents, datasets and links provided.

[@LearnitTraining]

You are welcome!

[@tonyc945]

I like the instructor's clear and articulate style. Unfortunately, the examples (at the 31 minute mark) regarding Average Sales Per Product Category returns the wrong result. There should not be an "ALLSELECTED" function at the end, because it removes the filters inside the query. Each category should have a different average not the same. To correct the DAX formula, remove the "ALLSELECTED" function, do small multiples with the product category, and you will then see the correct result.

[@LearnitTraining]

Noted! Thank you for the tip!

[@Anti-heroine]

I did this and now I can't see any results in the modelling view. It says there's a calculation error

[@joseernestosabatercalvet1810]

Thank you again for this session. Appreciate your detailed explanation!

[@LearnitTraining]

Glad it was helpful!

[@laissezfairez]

This series is too good to be true

[@LearnitTraining]

Thank you for watching!

[@AryaPaul-xq9wl]

Thanks a lot for the wonderful course. appreciated.

[@LearnitTraining]

You are very welcome!

[@watchandrewind]

Your video is so good and explanatory. I have one question I want to learn how can we add more than one excel file from data source settings

[@LearnitTraining]

Combining Multiple Excel Files: If you want to combine data from multiple Excel files into one dataset, follow these steps: Go to the Home tab in Power BI Desktop. Select Get Data and choose Excel as your source. Follow the prompts to select the files you want to import and set your data transformation options

[@Maks-u5e3k]

Thank you, the video was very helpful👍

[@LearnitTraining]

Glad you learned so much!

[@bhaveshkilaru7555]

Hey, Where can I find documents you mentioned in the course? I cannot see them in Manuals

[@LearnitTraining]

Exercise Files: bit.ly/2W9iMvZ

[@not_amanullah]

This course is helpful ❤

[@LearnitTraining]

Glad you think so!

[@lakshaysoni2515]

When we use a direct query, will it refresh the data when we open a direct query, or do we need to open the original data, update it, and then open direct query data???

[@jyothipvs828]

Mam,You are just amazing,the way the tutorial is organized,the contents u have put in ,the speed with which you deliver, everything is fabulous,no words but just amazing...please make one on SQL also ....

[@LearnitTraining]

Thank you for the kind words Jyothi! We do have a new SQL video coming soon!

[@jyothipvs828]

@@LearnitTraining Waiting mam ...

[@judechidozieezenyi9493]

If anyone is also getting this: At 16:41 I got the error, "Loading blocked by failures with other queries." In one of the error prompts, the table that's responsible for the error can be seen as it's the one with more info. Opening PowerQuery and refreshing from there seemed to fix this problem for me. Was able to then "Close and Apply" in PQ and refresh again on desktop and it was fine...

[@LearnitTraining]

Thank you for the tip!

[@TheMysterySolvedFox]

Thank you...... Table "Orders by Region". Open the PowerQuery, select this and refresh.... Thankssssssssssssssssssss 🙂

[@judechidozieezenyi9493]

@@TheMysterySolvedFox How good is your R programming?

[@olamidelawal7468]

Thank you Jude for this tip, I saved my excel before refreshing on Power query and it worked just fine.

[@judechidozieezenyi9493]

@olamidelawal7468 Oh, no problem at all. All the best with your learning! 💪 Learning other programs as well?

[@box5329]

Very clear and easy to follow, a really useful learning video!👍

[@LearnitTraining]

Glad it was helpful!

[@utkarshapawar6229]

Good Afternoon mam... Your teaching method is very amazing it's really understandble I create powerbi report simultaneously ...I have one dought in verible chapter

[@LearnitTraining]

Thank you for watching!

[@kush4286]

This woman is a god send…my goodness…

[@LearnitTraining]

Thank you for watching!

[@osoriomatucurane9511]

What was the reason to create the table with distinct orders? If we only wanted the number of orders made, there should be a much simpler way of getting the count of distinct orders. I really appretiate if you could explain and clarify this point.

[@hsoyaivtogeu8025]

cam on ban/ban rat nhieu xuat hien dung luc minh can yeu giong ban qua

[@LearnitTraining]

Không có chi! Cảm ơn vì đã xem!

[@ItsWithinYou]

Amazing! Thank you for sharing!

[@LearnitTraining]

Our pleasure!

[@Gorskiszlak]

41:01 here I got an error message "Unable to finish validation" and I had no idea what to do. This is system bug and I had to download latest PowerBI desktop version. Perfect lesson btw.

[@261219861]

Hello, Madam, your teaching and explaining things is quite interesting and quite easy. So could you provide me the link to download the POWER BI into my windows.

[@LearnitTraining]

www.microsoft.com/en-us/power-platform/products/power-bi

[@diamondsandlipgloss]

at 2:15, does anybody know why we started by clicking on the modeling tab instead of transform data? and, creating the column w/ the distinct numbers looks like the Order ID column was copied... so I"m wondering whats a realistic reason for needing to know how many order id's there are?

[@LearnitTraining]

Hello diamondsandlipgloss! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

[@diamondsandlipgloss]

@@LearnitTraining not sure if you're a bot, but if you're an actual person, you've said that w/each of my comments, but no one answers me on that forum.... therefore my question is to other viewer who may answer here on KZbin 🙂

[@sarahf6968]

I guess somethings can be done without using power query so we didn’t click transform data,, not sure tho However we didn’t copy the Order ID column, if you noticed the rows in the new column are 1746 while OrderID in Order table has 2428 rows. It basically shows the distinct values. Several Products can be in the same order so they all will have the same OrderID and it will be repeated for each one. So thee realistic reason would be to know how many orders were made! I hope that made sense

[@abeerattia4523]

Thanks for this excellent lecture

[@LearnitTraining]

Most welcome!

[@abcxyz6606]

Thank you for the Videos. Question on Rank Function, can it rank with Multiple Partitions and Order by multiple fields? Example: can it rank by Grouping the State, City, Product then Order by Sales Total and Cost by Goods? Thank you!

[@perfectionist6624]

Thank you for your hard work. Can u please keep long distance in advertisement? I m loosing focus due to too many ads within 5 min interval

[@LearnitTraining]

Noted

[@perfectionist6624]

@@LearnitTraining thanks a lot

[@marshallhosel1247]

Thanks for your video.

[@LearnitTraining]

You are welcome!

[@maltisingh-ds6rm]

This whole playlist is enough to prepare full power bi?

[@LearnitTraining]

Yes, it will give you a solid foundation to create all types of data visualizations.

[@maltisingh-ds6rm]

Thank you so much

[@siphokuhle__329]

Hi, I appreciate your videos so much. Thank you for taking the time to make them. I have a small problem though, my PowerBI desktop application is apparently not compatible to open the Retail Analysis Sample file. I am having trouble moving forward with my learning due to this, can you please tell how I can fix this?

[@TheFrancisChowdhury]

Awesome. Nicely explained.

[@LearnitTraining]

Thank you 🙂

[@niklase5901]

In this video the fields related to customer and product are taken from the order-table. Why make dimension-tables for customers and products in the last video if they are not used?

[@Hemant13832]

At 17:00 there is need to seach of numeric numbers from order id & sales ranking lowest column but there is no such search box appearing in numeric columns (available in string columns), is there any setting I need to do, plz tell If you know?

[@fog2640]

finished watching

[@LearnitTraining]

Thanks for watching!

[@extrov1]

thanks so much for the for the excellent and clear way of teaching ............ i have question on Dax formula : End Of Quarter = ENDOFQUARTER(Orders[Order Date]) when i apply it the output is like (3/12/2004) , it does not giving me the (3/30/2024), as the same as the (ENDOFQUARTER) DAX formula ??!!

[@cajithingeorge]

Thanks a lot

[@LearnitTraining]

Most welcome!

[@salawuoyindamola5590]

while working with real world experience, will I get a place where I can read the functions ?

[@cathyzhou8898]

thank you!

[@LearnitTraining]

You are welcome!

[@saidufaramabangura8221]

Thanks so much. The training is wonderful and I learnt so much. Would appreciate if you do a consolidated FS presentation

[@LearnitTraining]

We will look into that! Thank you for watching!

[@fog2640]

finished practicing

[@LearnitTraining]

Awesome! Keep it up!

[@chapaithefirst1028]

18:18 Unfortunately I don’t have a string Search when I try to sort datas in a column. In Transform Data it’s all right, but it’s useless for Days to ship etc. Though with text column non there is such problem.

[@LearnitTraining]

Thanks for the tip!

[@MrAimalsultani]

Well-Done

[@LearnitTraining]

Thank you!

[@nandowilliamk]

Can I get some help? I don't have the search bar on the Order ID's drop down menu.. 17:22

[@LearnitTraining]

Hello Fernando! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

[@ahmadaltaweel4981]

Thank you 💕

[@LearnitTraining]

Thank you for your continued support Ahmad!

[@gerrypomanski1967]

In the multi label card the category labels not showing, just the word Blank above the value?

[@Kcee_duru]

I’m having difficulty in loading the Retail Analysis Sample dataset

[@dishantchokhandre2285]

I believe your explanation for quick measure is wrong. We are not getting the averges by customer segment in the visualization. What the measure did is - it took the base value i.e. average of total sales entirely, and then as we added totals per category, it made the category i.e the customer segment irrelevant, that is why you are seeing the distribution of that measure around customer segment showing the same value.

[@LearnitTraining]

Thanks for the feedback!

[@clairejsquibb]

For me, trying to create the quick measure Average Sales by Customer Segment crashes Power BI when I bring up the dialog to change Sum of Sales to Average of Sales (as you do at 23:32). The dialog contents disappear and a blank grey box is shown, modal until I close it on the taskbar.

[@dbr2msf]

Hi Claire, I'm having exactly the same issue. Did you find a solution? Thank you, Mark

[@dbr2msf]

I found a solution to this provided by MS within the PowerBI community. Options - Global - Preview Features - uncheck (disable) Power BI Desktop Infrastructure update. Restart Power BI. This solved the issue for me. Thanks Mark

[@clairejsquibb]

@@dbr2msf Thanks so much for digging this out, Mark - I shall try again!

[@tonyc945]

@@dbr2msf Thanks, Mark. Problem solved for me also.

[@niitnahuja8793]

Hi Claire! You seem to have seen viewed PowerBI classes from both Chelsea Dohemann and from Trish Conner-Cato as well. I have only seen the 3 tutorial classes by Chelsea. Would you recommend me to watch these tutorials as well?

[@allisonnosilla9796]

At 41:45, the Dates table is not showing up under relationships. What do I do?

[@klarawijs]

Maybe it's on the far right side, try and scroll more to the right. That was my case, hope it helps!

[@allisonnosilla9796]

@@klarawijs Resolved by closing and reopening file. Maybe it was a cache issue.

[@lavanyabhardwaj8730]

40:03 Showing invalid formula It says function ADDCOLUMNS expects a column name

[@punitkaur7572]

Hey can anyone tell me, does this video cover DAX topic?

[@LearnitTraining]

We did quite a few shows on DAX - kzbin.infogj3xbZZEAcQ

[@Hemant13832]

Can you share the file of tables used in Retail Analysis sample?

[@Wandersong13]

After declaring the variables in the meaures 2010 ,2011 and 2022 , once i use the multi row card visualization i recieve the following error , Cannot covert value 'January' of type text to type Date while processing column - dates[month] -> Orders[Orders date]. How to resolve this, where did i go wrong

[@LearnitTraining]

Hi Buddhist! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com

[@huyquang2867]

at 17:03, why can't i see the search box while some other columns have it and some don't

[@Hemant13832]

Find any solution?

[@akosasuke5128]

Do I need a Power BI paid subscriptions at any point in this course?

[@LearnitTraining]

No, you can do the whole video with the trial version.

[@akosasuke5128]

@@LearnitTraining thank you for the response, I will be commencing lectures.

[@allisonnosilla9796]

QQQ: Date Table card is not showing in model view. Re-did Sample Superstore, everything is exactly as you have. Was able to edit relationship by right clicking Orders, making 1 to many relationship but Date Table catd still does not show in model view. Is there some setting that needs to be changed in order for it to show Date Table card? Please advise. Thanks.

[@muhammedragheb2141]

i can't find the power bi data set icon

[@utkarshapawar6229]

When I am create 2010 corporate segment total sales measure and similarly for 2011,2012,2013 years it's all values are same and values also not correct as per your report????

[@LearnitTraining]

Hello Utkarsha! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

[@RMKserve]

I need the lense of James web telescope to see what u write in Dax formula bar. Plz Increase zoom ratio.

[@LearnitTraining]

Noted!

[@chad_the_stud]

fingers crossed for PowerApps beginner to advanced videos

[@LearnitTraining]

Hi Burak! Yes PowerApps and PowerAutomate are two videos scheduled for production soon!

[@opeoluwafadele2528]

@@LearnitTraining Thank you so much. I love the video it is very simple, plain, and easy to follow, understand and apply at the same time.

[@petecardona8203]

we can only work with the desktop files as we don't have an account for web files.

[@RavinderKumar-gl8cy]

Sir, How we can do the function similar to Indirect function in Excel, in power BI. For Ex. I am having a slicer with the name of all Indian states, If I don't select any thing from slicer, then in the table for ROW value , name of state should come and their population will come from measure. If I select any state from slicer , then in the table, respective district list should appear and there population. Please advise how we can do this.

[@LearnitTraining]

Hello Ravinder! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

[@ashwinikhobragade7583]

Direct query doesn't bring data into power BI so how can we perform queries with data like Dax, modelling, data shaping etc? Pls elaborate

[@Anchal-o2r]

@LearnitTraining I am getting error while performing this expression Dates = ADDCOLUMNS (CALENDARAUTO (), "Year", YEAR ( [Date] ), "Quarter", "Q" & QUARTER ( [Date] ), "Month", FORMAT ( [Date], "mmmm" ), "Month Number", MONTH ( [Date] )) Can you help me

[@tanveerabbas3271]

thk u❤

[@LearnitTraining]

You are welcome!

[@nikhilnale9473]

can you please upload a project on power BI

[@moldovandorin6187]

why for some years the end of July month (say) is 31 and for other years is 28 or 29? ... and what the point of a function like CALCULATE(SUM())? Isn't Sum by itself going to do it and we don't need the CALCAULTE function?

[@pavanichinni9889]

Mam I was getting an error while opening retail analysis sample from power BI dataset as "We couldn't connect to your model in the Power BI Service. The dataset may have been deleted, renamed, moved, or it is possible that you don't have permission to access it".

[@faisalaziz519]

HI the vedio quality is very poor, I can hardly read any thing.

[@faisalaziz519]

My vedio quality was set to low so in setting i adjusted it, now its working, please ignore my previous comment. thanks

[@2took]

Can't publish to the service. How do I get the service without the "work" email address?

[@LearnitTraining]

Hello 2 Took! To publish in Power BI you will need a least a Power BI Pro license.

[@mayachandrarajbongshi6651]

Why this irritating add again and again

[@rakeshnag70]

it is basic

[@LearnitTraining]

Noted!