NB all, the SharePoint List doesn't work (or at least it doesn't for many of us) but that's OK - it's just a demo and that table is never used. Don't waste your time on trying; just watch the video and see how you would be able to connect to your own SharePoint Lists, if you have access to such things. And a lot of people are asking about Day 4: it follows on from Day 3 IN THIS VIDEO. See the timestamp for "Introduction" at 1:23:40. I'd like to express my thanks for this great set of tutorial videos. Not exactly up-to-date as regards the UI (I'm watching in August 2021), but if you look for things carefully, it's not too different. Power BI is very much a moving target!
One other suggestion for those of you watching this tutorial. When Chelsea says to remove items from the fields area BEFORE moving on to next topic, simply create a blank/duplicate page. That way you will keep all the information that you can later use when you are dealing with your data. Anyway, wish I would have done that, but now I'm finished with the tutorial.
Hi Chelsea, Its a great tutorial. I just finished watching the power bi series. It was a great work. Easily understandable to even a person without any knowledge about this software. Keep up your good work. Thank you.
great and powerful resources and Tutorials. my greeting for the instructor, she is amazing and know exactly how to explain each topic and know how to select sample to show her vision.
Amazing tutorial! I solved the problem that puzzled me for weeks by watching this video very thoroughly. While I noticed at 1:49:10, the % Total Sales of Parent Category is actually the % of Total Sales negating all categories not the % of Parent Category (Audio; Camera and camcorders; Cell phones). Not sure if I misunderstood anywhere...
At 52:00, shouldn't formula be opposite? like current month - prev month / current month? That will give us positive or negative growth as compared to prev month
Can't coonect to the sharepoint, it says that "We could'nt authenticate with the credentials provided. Please try again". And, I am signed in with my microsoft account. What am i doing wrong here?
Last exercise from day 3 - wouldn't reversing relationship from "colors unique" "colors" and making it "many to 1" work as alternative to creating a measure?
Instructor Chelsea is excellent. Content was very valuable. I did find that some of the information is different based on the newest upgrades, however I was able to complete all of the tutorial with a few variations.
This is the best course I've ever found on this. Thank you so much for sharing. Question though. When making the dates table, I typically list the dates, then in the data model. I think that option taxes the processor instead of the ram. Do you have an opinion which way is best? (Assuming you have 30 years of dates or something like that)
1:16:00 Why there is problem with many to many relationship in power bi ? I know there is not this possibility in power pivot .... but in power bi I have created a lot of these and they work perfectly
Thanks for these great videos. Why can't we apply multiple filter conditions in the same calculate function for all product categories? Why to create separate measures?
Thank you so much for this course I finished the three tutorials but I have a problem I can't sign in on line because I don't have a company email any solution??
It's ok. She doesn't use the data in the remaining parts of the video. So you and everyone else can continue with the tutorial. When I first hit the snag as you did, I contacted LearnIt to see if they could adjust the SharePoint permissions, but they said they couldn't. Then I continued to play the video and then found out the data wasn't going to be used.
Thank you so much for the awesome tutorial. One question.If I write a program that will update data regulary, can PowerBI automatically update the charts?
Can you help me out with the average promo calculation and hi-low promo visual In most measures, you read the Dimension column and aggregate by the fact table. Product name > Fact Table > Total sales visual In this case your going Product> Totals Sales. and then you're reading the promo amount off of the Promotion table? it's very confusing because the only promotion data we have on the Fact Table is a Promo Key number and not a discount percentage. How are we aggregating data that's only on a dimension table?
Hi guys... when trying to connect to your "sharepoint online list" as per the video walk-through around the 3:53 mark, I'm getting an error... "Access to the resource is forbidden." Has the resource been shut down now?
1:23:14 segment, I am getting all Color Theme same number 2282482. I cannot figure out the problem. I have added same formula as you have done CountOfSalesQuantiy = CALCULATE(COUNT(FactSales[SalesQuantity]),Colors). But your result and my result are different. Can you please let me know where is the problem? At least little hints. Thank you for your excellent presentation. I have learnt lot.
Is there a fourth tutorial in this series? I'm currently on this episode but the day files are four (4) in total but I cannot find the fourth tutorial. Anybody that has come across the fourth tutorial, if any, should kindly reply this comment with the link to it. Thanks!
AT 1:48 I believe the measure is incorrectly labeled. The percentage actually calculates against TOTAL SALES NOT the PARENT CATEGORY. If anyone else sees it this way, please let me know since I may be thinking about it wrong. Thanks.
Great Tutorials however, for this I am not able to proceed - even when using "Anonymous" I am getting credentials error. Anybody has any idea how to resolve this? Tia.
I think for 1:49:00, the %TotalSales is calculated against the sales of all categories, not just each parent category. Is there anyway to just calculate foreach category?, i.e. sum of % for each category is 100%
Hello! Please fix this, it seems that many other has the same problem! I Cannot download Day3 workfiles. The PBIX file is larger than the allowed download size on your onedrive. Please advise. Thanks
Hi LearnIT guys, thanks for great tutorial! At 53:45 one of the values in Pct Change column is infinity....what can be done to the formula to get rid of that? I tried using calculate function and excluding TotalSalesPrevMonth 0, but it throws an error. Thanks!
Cannot access the Sharepoint Data. Even though I am connecting Anonymously, I get the message "We could not authenticate with the credentials provided"
Hi, I have a doubt, when you create Month Name it is in Text data type, however when you start with DatesYTD they are shown as January till December for each year, are there any changes that you have applied?
Hi, for some reason all of my values in the tables are exactly the same. So for example TotalSalesMTD, all of the values underneath are the same. The value in the first row is $8,467,938,313.52 and in the second one it's also $8,467,938,313.52? I think there is something wrong with my TotalSales table or something. Can you please tell me what might be wrong with it?
hi, I still do not get the last lesson in day 3. How can Power BI calculate the count of sales quantity by color using the table "Colors" when there is no relationship between ColorsUnique, Colors and FactSales?
Thank you so much Chelsea for creating the best Power BI course! I’ve got one question, at 1:49, why do the results of the measure % TotalSales of Parent Category turn out to be percentages of total sales? Isn’t the measure TotalSales All ProductSubcategories supposed to keep filters in the Product table while negating all the filters in the ProductSubcategory table? For example, in the first row, it should be the total sales of Bluetooth Headphones divided by the total sales of Audio, since Audio has been filtered out before ALL(product subcategory) function is applied, and according to the order of operations, Product Category table is in a higher position. Please help me out...
problems with importing the sharepoint list. keep getting error message "we couldn't authenticate with the credentials provided" even though anonymous is selected. No option to change credentials. So stalled at beginning of lesson. Maybe LearnIT could provide some dummy credentials??
In the last video, we created the profit by year and month chart. I have reordered and sorted it out by MonthNum or Year&Month. But it came up with January 2014, January 2015, January 2016, and February 2014, Feb 2015 etc. How can I fix it and make it to be right order (Jan2014, Feb 2014, March 2014 ex)? Please help me
Whenever it try to connect to sharepoint it says we couldn’t authenticate with the credentials provided. Not sure why this is an issue, I logged into my Microsoft account just fine. Wonder what I’m missing...
Any updates on this problem? I have tried several times as well to get the workfiles. Course is great but so frustrating when you can get the work files. Thanks!
NB all, the SharePoint List doesn't work (or at least it doesn't for many of us) but that's OK - it's just a demo and that table is never used. Don't waste your time on trying; just watch the video and see how you would be able to connect to your own SharePoint Lists, if you have access to such things.
And a lot of people are asking about Day 4: it follows on from Day 3 IN THIS VIDEO. See the timestamp for "Introduction" at 1:23:40.
I'd like to express my thanks for this great set of tutorial videos. Not exactly up-to-date as regards the UI (I'm watching in August 2021), but if you look for things carefully, it's not too different. Power BI is very much a moving target!
Thank you for the kind words Claire! Our updated Power BI videos will be coming out next week!
The best tutorial I've found. Because of you, I managed to create my own dashboard that I'm using in our company. Thank you so much!!!
Glad it helped!
One other suggestion for those of you watching this tutorial. When Chelsea says to remove items from the fields area BEFORE moving on to next topic, simply create a blank/duplicate page. That way you will keep all the information that you can later use when you are dealing with your data. Anyway, wish I would have done that, but now I'm finished with the tutorial.
😭❤️
does anybody have trouble connecting to the sharepoint list (04:33)?
wow ! Chelsea you're great teacher... I followed from day 1 to day 4. you know well both the tool and the data. Stay blessed and caring
Hi! Where did you find day 4? I can't find it on youtube
plz tell us wheres day 4 plzz🥺
@@achinthya97 Day 4 is the second half of this video, starting at about 1:23:40
Great job! I had some Power BI courses before but none of them has the amazing details you explain in this video. Thank you so much for it!
You are very welcome Alazir! Thank you so much for your support! It helps us continue to create new videos!
Best teacher I have seen ever. Thanks so much.
You're very welcome!
One Course to Rule them all.. Thank you very much! very informative
You are very welcome Name Less! Great name by the way!
Dear Chelsea,
Thank you so much for your amazing tutorial. I really enjoy it and love it .
Thank you so much.
Nice one Chlesea.
best PowerBI course to day
Hi Chelsea,
Its a great tutorial. I just finished watching the power bi series. It was a great work. Easily understandable to even a person without any knowledge about this software. Keep up your good work.
Thank you.
You're very welcome!
Did you land some job?
All 3 videos are amazing 🐱🐱🐱 waiting for more power bi content
Hi Bemals! In February we will have LIVE session planned. Details coming soon!
Thank you for creating this course. This is very much helpful.
You're very welcome!
Learned a lot through the 3 series, thank you for creating the tutorial!
great and powerful resources and Tutorials. my greeting for the instructor, she is amazing and know exactly how to explain each topic and know how to select sample to show her vision.
You're very welcome!
Chelsea is such an amazing teacher. Keep it up
We will!
Hi...Excellent class ...could you please upload the day 4 session also ...Thank you
So lucky to find these courses which helped me a lot! Thank you soooo much~Great Course!
Amazing tutorial! I solved the problem that puzzled me for weeks by watching this video very thoroughly. While I noticed at 1:49:10, the % Total Sales of Parent Category is actually the % of Total Sales negating all categories not the % of Parent Category (Audio; Camera and camcorders; Cell phones). Not sure if I misunderstood anywhere...
its best course ever
Best comment ever!
Very well taught ..from scratch to pro💯🤙🏻🤙🏻
Glad it helped!
By far the best tutorial online. Clear and easy to follow. Thanks a lot.
Thanks a lot Chelsea!
You're so welcome!
Thank you for those 3 tutorials! You are a beast!
Our pleasure!
Your Tutorials where awesome when are we expecting day 4 and 5 uploaded? Hope to hear from you soon I have already Subscribed to you guys
There is no day 5, at least not online.
@@fernandozambrano4102 Is there day 4? If yes, kindly reply with the link. Thank you
At 52:00, shouldn't formula be opposite? like current month - prev month / current month? That will give us positive or negative growth as compared to prev month
I think (current month - Prev month)/(Prev month) if you want to see the grow or loss from previous sales.
Can't coonect to the sharepoint, it says that "We could'nt authenticate with the credentials provided. Please try again". And, I am signed in with my microsoft account. What am i doing wrong here?
Thank you for the whole course!
You're very welcome!
So brillant course. Hope to see in the future deeper M and deeper DAX. You are doing amazing job, that You are sharing, knowledge with us. Thanks!
i like the term complicated relationships.. :)
LOL!
I would request Learnit to upload Day 5 class as well. I would really appreciate if you could do this - Learnit Team
abe day 4 ki to dalli nahi day 5 kaha se bahuch gaya ??
@@NipunRawat08 bhai day 3 and day 4 combined h ek baar dekh pehle...😂😂
Excellent !!! Thank you very much!!!
You are welcome!
Great class!!, thanks for your help!
You're very welcome!
Last exercise from day 3 - wouldn't reversing relationship from "colors unique" "colors" and making it "many to 1" work as alternative to creating a measure?
This has been an amazing indepth guide on PowerBI, detailed and very well layed out!
Thank you kindly!
Did you land some job?
Great Tutorial spoilt by too many interruptions for ads !
Instructor Chelsea is excellent. Content was very valuable. I did find that some of the information is different based on the newest upgrades, however I was able to complete all of the tutorial with a few variations.
This is the best course I've ever found on this. Thank you so much for sharing.
Question though. When making the dates table, I typically list the dates, then in the data model. I think that option taxes the processor instead of the ram. Do you have an opinion which way is best? (Assuming you have 30 years of dates or something like that)
Hello TheDanielsony! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Hi thank you for the nice video. One question, what if we have multiple things to be unpivoted? Is it the same way just don't select the column?
1:16:00 Why there is problem with many to many relationship in power bi ? I know there is not this possibility in power pivot .... but in power bi I have created a lot of these and they work perfectly
It is a brilliant tutorial. Thanks a lot!!!
You are welcome!
Thanks for these great videos.
Why can't we apply multiple filter conditions in the same calculate function for all product categories? Why to create separate measures?
Hi Firdaus! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
Thank you so much for this course I finished the three tutorials but I have a problem I can't sign in on line because I don't have a company email any solution??
Thanks A LOT.
Where can I find the Contoso Sales Customers dataset, please?
Exercise Files: bit.ly/2S4ARFI
Thanks for all the knowledge and training, it was superb
Excellent explanation
I'm also stuck at 04:25 connecting the SharePoint sire.
Thank you. Great presentation.
I have just discovered Chelsea's training videos. Can you please tell me where to get the sample (student) data files?
Thanks very much!
Hi Rich! The link to the exercise files is in the video description
Access to the resource is forbidden - what is the solution?
The solution is to ignore that and continue with the tutorial. You won't need that data, as Chelsea says in the video.
It shows an error with the message "forbidden" when I try to get data from sharepoint. Please help!!!!
It's ok. She doesn't use the data in the remaining parts of the video. So you and everyone else can continue with the tutorial.
When I first hit the snag as you did, I contacted LearnIt to see if they could adjust the SharePoint permissions, but they said they couldn't. Then I continued to play the video and then found out the data wasn't going to be used.
@@tonyc945 okay thanks .
Thank you so much for the awesome tutorial. One question.If I write a program that will update data regulary, can PowerBI automatically update the charts?
Hello ycbq999! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
The total for every year in your power bi is showing below December, but in my power bi, it is showing above January for every year? Any explanation?
Understood USERELATIONSHIPS, but what was the purpose of 'TotalSales by Due Date'? What was the insight? Not getting it.
How to add additional table in relationship fields? Thank you
Can you help me out with the average promo calculation and hi-low promo visual
In most measures, you read the Dimension column and aggregate by the fact table. Product name > Fact Table > Total sales visual
In this case your going Product> Totals Sales. and then you're reading the promo amount off of the Promotion table? it's very confusing because the only promotion data we have on the Fact Table is a Promo Key number and not a discount percentage. How are we aggregating data that's only on a dimension table?
Great course and thank you for the Brilliant course
Files aren't downloading larger than 25MB from your exercise File
Do we need a subscription in downloading tutorial content files?
You do not need a subscription to download the exercise files
Hi guys... when trying to connect to your "sharepoint online list" as per the video walk-through around the 3:53 mark, I'm getting an error... "Access to the resource is forbidden." Has the resource been shut down now?
1:23:14 segment, I am getting all Color Theme same number 2282482. I cannot figure out the problem. I have added same formula as you have done CountOfSalesQuantiy = CALCULATE(COUNT(FactSales[SalesQuantity]),Colors). But your result and my result are different. Can you please let me know where is the problem? At least little hints. Thank you for your excellent presentation. I have learnt lot.
I am very very Happy to hear 'everytime' from Chelsea, when you she says "Friendly Calculate Function" 🌝
Me too!
Is there a fourth tutorial in this series? I'm currently on this episode but the day files are four (4) in total but I cannot find the fourth tutorial. Anybody that has come across the fourth tutorial, if any, should kindly reply this comment with the link to it. Thanks!
Hi Prince! This is the 4th episode of the series. The 3rd video would be the expert tutorial.
It won't allow me to access the demo data. I get a message forbidden when I try to connect to the sharepoint data
same here.. anyone can help here ?
AT 1:48 I believe the measure is incorrectly labeled. The percentage actually calculates against TOTAL SALES NOT the PARENT CATEGORY. If anyone else sees it this way, please let me know since I may be thinking about it wrong. Thanks.
Yes I saw it the same way as you did. Maybe just some mistake, I guess.
Great Tutorials however, for this I am not able to proceed - even when using "Anonymous" I am getting credentials error. Anybody has any idea how to resolve this? Tia.
Hi Issa! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
Great course! Thanks!
Hello. Many thanks for this awsome training session. I see that Competitor Report Excel is password protected. Can you share same?
Hi Veemal! You can download the file locally and make any changes you want then.
Hi - does anyone have a fix for the "Access to the resource is forbidden" issue?
A shame as the first two videos were awesome!
The solution is to ignore that and continue with the tutorial. You won't need that data, as Chelsea says in the video.
@@fernandozambrano4102 Thanks!
Thank you
You're welcome!
Amazing video and very helpful!
Glad it was helpful!
@@LearnitTraining you could also reply to doubts related to power bi asked in comments section, no?
excellent course, looking forward to day 4 and day 5 upload also.
Day 4 is starting at 1:23:40 in this video
I think for 1:49:00, the %TotalSales is calculated against the sales of all categories, not just each parent category. Is there anyway to just calculate foreach category?, i.e. sum of % for each category is 100%
very well explained details
Hello!
Please fix this, it seems that many other has the same problem!
I Cannot download Day3 workfiles. The PBIX file is larger than the allowed download size on your onedrive. Please advise.
Thanks
I have the same problem
Very Well done !!!
Thank you for the kind words Harshal and an extra big thank you for subscribing!
Thank you 👍
No problem 👍
Hi LearnIT guys, thanks for great tutorial! At 53:45 one of the values in Pct Change column is infinity....what can be done to the formula to get rid of that? I tried using calculate function and excluding TotalSalesPrevMonth 0, but it throws an error. Thanks!
Hello Sergii! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Cannot access the Sharepoint Data. Even though I am connecting Anonymously, I get the message "We could not authenticate with the credentials provided"
Hi, I have a doubt, when you create Month Name it is in Text data type, however when you start with DatesYTD they are shown as January till December for each year, are there any changes that you have applied?
Hi, for some reason all of my values in the tables are exactly the same. So for example TotalSalesMTD, all of the values underneath are the same. The value in the first row is $8,467,938,313.52 and in the second one it's also $8,467,938,313.52? I think there is something wrong with my TotalSales table or something. Can you please tell me what might be wrong with it?
Great 3 videos! Totally worth the hours!
Glad you enjoyed it William Kiong!
hi, I still do not get the last lesson in day 3. How can Power BI calculate the count of sales quantity by color using the table "Colors" when there is no relationship between ColorsUnique, Colors and FactSales?
Excellent!
Thank you! Cheers!
1:21:05 what if you change the relationship to be bidirectional?
Does power BI auto query-ing pulling the data source (daily) without user having to open Power BI nor having to have to turn on the machine?
Hi Dee N! You can ask our instructors questions directly on Offsite our online community - bit.ly/30HMjvw
Thank you so much Chelsea for creating the best Power BI course! I’ve got one question, at 1:49, why do the results of the measure % TotalSales of Parent Category turn out to be percentages of total sales? Isn’t the measure TotalSales All ProductSubcategories supposed to keep filters in the Product table while negating all the filters in the ProductSubcategory table? For example, in the first row, it should be the total sales of Bluetooth Headphones divided by the total sales of Audio, since Audio has been filtered out before ALL(product subcategory) function is applied, and according to the order of operations, Product Category table is in a higher position. Please help me out...
i have the same question
2:03:53 why you don't use SelectedValue or created a what if scenario?
Were those available 3 years ago?
@@pabeader1941 Yes.
thx for pointing out a more straight-forward way to do this
problems with importing the sharepoint list. keep getting error message "we couldn't authenticate with the credentials provided" even though anonymous is selected. No option to change credentials. So stalled at beginning of lesson. Maybe LearnIT could provide some dummy credentials??
All ok...don't need this file anyway..great lesson.
In the last video, we created the profit by year and month chart. I have reordered and sorted it out by MonthNum or Year&Month. But it came up with January 2014, January 2015, January 2016, and February 2014, Feb 2015 etc. How can I fix it and make it to be right order (Jan2014, Feb 2014, March 2014 ex)? Please help me
Add a new column in the dates table, use metric : YEAR ABC = Dates[Year]*100 + Dates[MonthNum] , then go back to report and choose sorting by YEAR ABC
nice content thank you
I am facing an issue. I have a matrix when I export it, its formatting get lost. Any solution for it? thanks in advance.
Whenever it try to connect to sharepoint it says we couldn’t authenticate with the credentials provided. Not sure why this is an issue, I logged into my Microsoft account just fine. Wonder what I’m missing...
Apparently it's not needed for the rest of the video. So simply follow along and it'll be fine :) . Had the same issue
Superb
i cant find the facts table in wrorkfiles
I don't have a office 365 account. How do I follow your instructions and complete the lab? Can I get a free account?
Hi Sandeep! You can start with Power BI for free.
Hello Chelsea,
I Cannot download Day3 workfiles. The PBIX file is larger than the allowed download size on your onedrive. Please advise.
Thanks
Any updates on this problem? I have tried several times as well to get the workfiles. Course is great but so frustrating when you can get the work files. Thanks!
Download the entire zip file, solved the problem for me
I can't find the video on day 2. That's a shame. Video tutorials are very good.
Day 2 is convered in the Advanced Tutorial video: th-cam.com/video/ppD-jKqsqKM/w-d-xo.html
Thank you, please post date table M code here
Set speed to 1.5 (or 1.75)