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.
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?
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...
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.
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??
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)
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?
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
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
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?
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, 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?
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?
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.
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.
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?
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?
Cannot access the Sharepoint Data. Even though I am connecting Anonymously, I get the message "We could not authenticate with the credentials provided"
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
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!
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?
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 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!
Hi, is there an alternative source on where I can get the files from sharepoint? I kept on trying to sign in for me to access it but it's always denied.
Hi J! The link is an open link so there are not any security settings on our end blocking access. We definitely recommend checking if you have a limit on the download size for files on you computer as that is typically the main culprit.
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%
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
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.
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??
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...
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...
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.
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)?
Best teacher I have seen ever. Thanks so much.
You're very welcome!
best PowerBI course to day
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!
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
Dear Chelsea,
Thank you so much for your amazing tutorial. I really enjoy it and love it .
Thank you so much.
Nice one Chlesea.
One Course to Rule them all.. Thank you very much! very informative
You are very welcome Name Less! Great name by the way!
Learned a lot through the 3 series, thank you for creating 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.
You're very welcome!
Did you land some job?
Thank you for creating this course. This is very much helpful.
You're very welcome!
Chelsea is such an amazing teacher. Keep it up
We will!
So lucky to find these courses which helped me a lot! Thank you soooo much~Great Course!
All 3 videos are amazing 🐱🐱🐱 waiting for more power bi content
Hi Bemals! In February we will have LIVE session planned. Details coming soon!
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!
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!
By far the best tutorial online. Clear and easy to follow. Thanks a lot.
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?
Thank you for those 3 tutorials! You are a beast!
Our pleasure!
Very well taught ..from scratch to pro💯🤙🏻🤙🏻
Glad it helped!
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?
its best course ever
Best comment ever!
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...
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.
Hi...Excellent class ...could you please upload the day 4 session also ...Thank you
Great class!!, thanks for your help!
You're very welcome!
Thank you for the whole course!
You're very welcome!
This has been an amazing indepth guide on PowerBI, detailed and very well layed out!
Thank you kindly!
Did you land some job?
Excellent !!! Thank you very much!!!
You are welcome!
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??
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/
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?
Excellent explanation
It is a brilliant tutorial. Thanks a lot!!!
You are welcome!
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
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 all the knowledge and training, it was superb
Understood USERELATIONSHIPS, but what was the purpose of 'TotalSales by Due Date'? What was the insight? Not getting it.
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.
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?
How to add additional table in relationship fields? Thank you
Thank you. Great presentation.
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?
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!
Thanks A LOT.
Where can I find the Contoso Sales Customers dataset, please?
Exercise Files: bit.ly/2S4ARFI
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
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?
Great 3 videos! Totally worth the hours!
Glad you enjoyed it William Kiong!
Thanks a lot Chelsea!
You're so 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?
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
Great course and thank you for the Brilliant course
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
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 facing an issue. I have a matrix when I export it, its formatting get lost. Any solution for it? thanks in advance.
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.
i like the term complicated relationships.. :)
LOL!
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 .
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 course! Thanks!
Great Tutorial spoilt by too many interruptions for ads !
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?
Cannot access the Sharepoint Data. Even though I am connecting Anonymously, I get the message "We could not authenticate with the credentials provided"
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
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
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?
Do we need a subscription in downloading tutorial content files?
You do not need a subscription to download the exercise files
I'm also stuck at 04:25 connecting the SharePoint sire.
Files aren't downloading larger than 25MB from your exercise File
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.
i cant find the facts table in wrorkfiles
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 ?
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.
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/
Very Well done !!!
Thank you for the kind words Harshal and an extra big thank you for subscribing!
very well explained details
Hi, is there an alternative source on where I can get the files from sharepoint? I kept on trying to sign in for me to access it but it's always denied.
Hi J! The link is an open link so there are not any security settings on our end blocking access. We definitely recommend checking if you have a limit on the download size for files on you computer as that is typically the main culprit.
this step appears to require an office 365 account that my organization doesn't have
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%
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
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
I am very very Happy to hear 'everytime' from Chelsea, when you she says "Friendly Calculate Function" 🌝
Me too!
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...😂😂
1:21:05 what if you change the relationship to be bidirectional?
Set speed to 1.5 (or 1.75)
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.
excellent course, looking forward to day 4 and day 5 upload also.
Day 4 is starting at 1:23:40 in this video
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
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
nice content thank you
Excellent!
Glad you liked it!
Thank you 👍
No problem 👍
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
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.
I am not able to download the Exercise file...
Here is the link Nihal - Exercise Files: bit.ly/2S4ARFI We just tested the link and files and they are currently working
I can't connect with the sharepoint link. Error message:"we couldn't authenticate with the credentials provided. Please try again."
Me too. I got the same message.
Thank you
You're welcome!
Superb
Hi, impossible to get files by the link "learnitanywhere.sharepoint.....