New Version Available: If you want to learn Power BI from the ground up-covering everything from basic data modeling to advanced DAX and real-world analytics-be sure to explore my 20-hour Masterclass, packed with 150+ essential topics to elevate your data analytics and business intelligence skills. th-cam.com/video/cyWVzAQF9YU/w-d-xo.html
🙏 Thank You for 100,000 Views & 2000 Likes! 🎉 I want to express my heartfelt thanks to everyone who took the time to view this video, designed for beginners and intermediates. This TH-cam video was launched just ten months ago and has now surpassed 100,000 views, with 2000 kudos from wonderful viewers like yourself. Your constant support and active engagement truly mean the world to me.
After completing the video, what I have realized is that one should already have some beginner-level proficiency in Power BI to understand the concepts explained in this video. Overall, well-structured video and covers many important concepts.
Absolutely the BEST Power BI course I've ever come across! 👏🔥 The content is incredibly well-structured, and the concepts are clearly explained. Perfect for anyone looking to master Power BI. Highly recommended! 💡💻.
Thank you very much for sharing this video. I've taken a Power BI course during my Masters degree in analytics and been working with Power BI for 9 months now. Yet, I want to mention that this Power BI tutorial has so much value.
Thank you 🙏 so much for your kind words and support! I'm truly grateful for your feedback. It's wonderful to hear that even with your experience and background in Power BI, you found value in this tutorial I have reorganized my 370+ videos, blogs, and files in 70+ hours of content on Microsoft Fabric, Power BI, and SQL and put it into a course on an LMS. Free as of now biworld.graphy.com/courses/Get-Fabricated-Learn-Microsoft-Fabric-Power-BI-SQL-Power-Query-DAX-Dataflow-Gen2-Data-Pipeline-from-Amit-Chandak-649506b9e4b06f333017b4f5
Hi Amit, I have been following you on various platforms and the simple language and examples makes your videos highly important and popular. I have just 1 request if you can also share the pbix files that you use on any particular topic, it will be a great help. Many Thanks 😊
this tutorial is very helpful, amidst an ocean of content present related to power BI ,this one stands out in clarifying the threadbare details of the Power Bi
Glad it was helpful! Thanks 🙏 Hope you will likes the other series too Mastering Power BI 230+ videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Power BI Concepts 160+ Videos: th-cam.com/video/59PUFuuCrbY/w-d-xo.html Mastering Microsoft Fabric 35+ Videos: th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
Thank you for your kind words! I'm glad you found my video informative. You can check out more video from other series Mastering Power BI: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Expertise Power BI: th-cam.com/video/59PUFuuCrbY/w-d-xo.html Mastering Microsoft Fabric: th-cam.com/video/p-v0I5S-ybs/w-d-xo.html Power BI Interview Questions Part 1 - 40 Questions: th-cam.com/video/vvFGAAbds1k/w-d-xo.html DAX vs SQL: th-cam.com/video/WlvQ_SGy4iA/w-d-xo.html Tableau Vs Power BI: th-cam.com/video/tAmg00Wf_cw/w-d-xo.html Power BI Decoding Direct Query: th-cam.com/play/PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA.html SQL - th-cam.com/video/ThCZYuYAbnY/w-d-xo.html
It seems like you are discussing the color measure. In this case, each point on the scatter plot represents a row, which in turn represents a city and provides a row-specific value. To calculate the overall average, we need an overall total or average. This can be done by using either the "all" or "allselected" functions in the measure. We prefer to use the "allselected" function because it allows us to ignore the row context without removing the filter context. What is the difference between all and allselected in dax/power bi? - th-cam.com/video/FTpc5IdT0Og/w-d-xo.html
Thanks for this tutorial and rhe timestamp Amit . This video covers everything that is needed .. Looking forward to more of your videos on some dax scenarios
Thanks a ton. 🙏 Hope you will like these series Mastering Power BI 230+ videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Power BI Concepts 160+ Videos: th-cam.com/video/59PUFuuCrbY/w-d-xo.html Mastering Microsoft Fabric 35+ Videos: th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
🙏 Thank You for 50,000 Views & 1000 Kudos to 11-hour video! 🎉 My sincere gratitude goes out to those who took the time to watch my video, especially the 11-hour full video for beginners and intermediates. This TH-cam video was launched just five months ago, has reached over 50,000 views, and received 1000 kudos from amazing viewers like you. I am extremely grateful for your continuous support and engagement. Your response has truly touched my heart and motivated me to continue creating valuable content to share knowledge with you. I am committed to delivering insightful and informative videos that empower you in your data analytics journey. I would like to extend my heartfelt gratitude to each and every one of you who watched, liked, commented, and shared my video. Your engagement and encouragement mean the world to me. If you haven't watched the video yet, I invite you to join the thousands of viewers who have found value in it. Simply click on the link below and embark on an exciting learning experience. Complete Power BI Video 11Hour: th-cam.com/video/cN8AO3_vmlY/w-d-xo.html Thank you again for taking the time to watch my video. Stay tuned for more exciting content, tutorials, and insights that will help you excel in the world of data analytics.
Thanks Amit for this am currently an hour into the training and I all I can say is thank you for taking your time to explain I am following the training and practicing at same time. When am done probably by tomorrow will drop my final review.
Thanks so much! I'll be looking forward to your final review. There's also a newer version available, and I'd be happy to give you access if you're interested biworld.graphy.com/courses/Power-BI-Full-Course-64279a37e4b039e3060146e9 If you need that, ping me on LinkedIn, I will enable the Enroll button- www.linkedin.com/in/amitchandak78/
Thanks David. Also, Please check videos on newly released Microsoft Fabric 17 Videos- th-cam.com/video/p-v0I5S-ybs/w-d-xo.html Mastering Power BI 200+ Videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Expertise Power BI 150+ Videos: th-cam.com/video/59PUFuuCrbY/w-d-xo.html DAX vs SQL: th-cam.com/video/WlvQ_SGy4iA/w-d-xo.html Tableau Vs Power BI: th-cam.com/video/tAmg00Wf_cw/w-d-xo.html
Really amit you did a fantastic job. No words for your explanation. You taught even small small things which is really helpful.... you deserve a more than one million likes
Thank you so much for your kind words and encouragement! It's truly rewarding to know that the video has been helpful and appreciated. I'm especially glad to hear that the detailed explanations were useful. If you have any suggestions for future topics or specific areas you'd like to learn more about, please feel free to share. Your support and engagement are incredibly motivating. Remember, every like, share, and comment helps others find and benefit from this resource, so your million-like wish really means a lot! 🌟 Happy learning and do stay connected for more content Once done, you can pick and choose topics from these two series Mastering Power BI 230+ videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Power BI Concepts 160+ Videos: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
Thanks 🙏. Hope you will enjoy these series Mastering Power BI 230+ videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Power BI Concepts 160+ Videos: th-cam.com/video/59PUFuuCrbY/w-d-xo.html Mastering Microsoft Fabric 40+ Videos: th-cam.com/video/p-v0I5S-ybs/w-d-xo.html Additional content on the channel Mastering Microsoft Fabric in Hindi: th-cam.com/video/6aduOToIwtg/w-d-xo.html Power BI Interview Questions Part 1 - 40 Questions: th-cam.com/video/vvFGAAbds1k/w-d-xo.html DAX vs SQL: th-cam.com/video/WlvQ_SGy4iA/w-d-xo.html Tableau Vs Power BI: th-cam.com/video/tAmg00Wf_cw/w-d-xo.html Power BI Decoding Direct Query: th-cam.com/play/PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA.html सीखे Power BI हिंदी में: th-cam.com/play/PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki.html Concepts of Business Intelligence: th-cam.com/video/bmhGLoT-_a8/w-d-xo.html SQL - th-cam.com/video/ThCZYuYAbnY/w-d-xo.html Tableau - th-cam.com/play/PLPaNVDMhUXGb5DWmhtg84df9AalKbptis.html Tableau- Hindi -th-cam.com/play/PLPaNVDMhUXGaYGdI0-30-kvR1eqVObHTl.html Power BI Hindi On Demand - th-cam.com/video/hgLIwUZq8zo/w-d-xo.html
Thanks, Hope you like other videos and series too Mastering Power BI 230+ videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Power BI Concepts 180+ Videos: th-cam.com/video/cAqjakPjbMU/w-d-xo.html Mastering Microsoft Fabric 50+ Videos: th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
Please refer to this series Power BI Concepts 180+ Videos: th-cam.com/video/cAqjakPjbMU/w-d-xo.html Also, refer how to break a file, in first few video of the series Mastering Power BI 230+ videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Thanks. Also, Please check videos on newly released Microsoft Fabric 17 Videos- th-cam.com/video/p-v0I5S-ybs/w-d-xo.html Mastering Power BI 200+ Videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Expertise Power BI 150+ Videos: th-cam.com/video/59PUFuuCrbY/w-d-xo.html DAX vs SQL: th-cam.com/video/WlvQ_SGy4iA/w-d-xo.html Tableau Vs Power BI: th-cam.com/video/tAmg00Wf_cw/w-d-xo.html
For city names without spaces, the function will return the value of the fourth parameter during a search. Typically, we use 0 as the fourth parameter. However, in this scenario, we want to return the length of the city name. Now, if there is a white space in a city name, such as "New York," the function will return 4. However, we only want to return 3 characters, as we don't want the white space at the end of the first name. In other words, we need to subtract 1. However, this subtraction of -1 will affect city names without spaces, as it would reduce the character count by 1. That's why we added one to the length of the city name when there are no spaces.
Sir i complete this video now I want start my first project in covid 19 so i have one question, without cleaning the covid data means without removing the null values in new death and new column can i start my build report? Sir please answer it🙏🏻☺
Yes, you can. Additionally, you can consider using a date table like we do in HR, joining with both dates and using USERELATIONSHIP for inactive joins. Power BI: HR Analytics - Employees as on Date : th-cam.com/video/e6Y-l_JtCq4/w-d-xo.html community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970 Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: th-cam.com/video/fvgcx8QLqZU/w-d-xo.html
Sir , have recently joined your channel, have watched your many solutions over power bi community post, which has helped me a lot. will watch this video in my weekends and will share the feedback, ❤❤
Thanks, Looking forward to it. You can refer to videos and playlists Complete Power BI in one Video: th-cam.com/video/cN8AO3_vmlY/w-d-xo.html Mastering Power BI: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Expertise Power BI: th-cam.com/video/59PUFuuCrbY/w-d-xo.html DAX vs SQL: th-cam.com/video/WlvQ_SGy4iA/w-d-xo.html Tableau Vs Power BI: th-cam.com/video/tAmg00Wf_cw/w-d-xo.html Power BI Decoding Direct Query: th-cam.com/play/PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA.html
This is blog link: amitchandak.medium.com/power-bi-interview-questions-part-1-4982de3be327 Videos I am uploading - They will part of this podcast - th-cam.com/play/PLPaNVDMhUXGbUzSOKy3A15J5wAgQedQtl.html
Hi @swatishankar-ww2vl, Thank you for contacting us. Please follow this link to start a Power BI Pro trial: github.com/MicrosoftDocs/powerbi-docs/blob/live/powerbi-docs/admin/service-admin-signing-up-for-power-bi-with-a-new-office-365-trial.md Thanks, Amit
Sir, what is the diffrenece between trailing year and LYTD. when i am adding them separtely on card the value for LYTD is lesser than the value of trailing year. what is the reason behind it... i am not able to understand. plz reply ASAP!!!
LYTD is last year till date. Trailing year is one year before data. If you select month Feb 2020. LYTD will be jan and Feb 2019. While trailing will be Fab 2019. On card visual, if there is no date in context. Then trailing is complete data 1 year before. While LYTD will be based on last date of date table.
thank you sir but sir, if we have 2018,19,and2020 data then trailing year will give us 2 years of data but LYTD is also giving 2 years of data if we click on 2019 it will give data of 2018 if we click on 2020 it will give the data of 2019 so it is also giving us 2 years of data. but th value on card is totally different. so sir what is the reason behind it i am not able to figure it out!!! @@AmitChandak
when you do not have a date in context, filter, or row(visual), like card visual, and no filter/slicer on the page. Then trailing year is the sum last -1 year of the whole data. But if you select 2020 in the slicer or it is row context, then you should get 2019. if 6 rules are followed Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI:th-cam.com/video/OBf0rjpp5Hw/w-d-xo.html amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4 th-cam.com/users/shortsown-TbwO95g Trailing year should give one-year back data for the year in a context filter or row. With month year it will give same month last year Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year)) Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))
16:28 Why is Vizualisation missing in my case? I have Filters and Fields, but no vizualisations. I have Graphs in the "Home tab - Insert". Maybe it does not make much difference, but is easier to follow the tutorial.
This is because of on-object interactions, which is enabled by default now. You can disable that as of now from File-> Options and settings -> Options -> Preview Features th-cam.com/video/IxeaaSr-TXo/w-d-xo.html
Open Power Query and mark first row as header. Discussed in this video after Power BI: Power Query Functions one must know : th-cam.com/video/cN8AO3_vmlY/w-d-xo.html
Power App is a good option if you enjoy creating apps and user interfaces. Otherwise Power Automate. Power Automate is a better option as you continue to optimize the data process
Make sure you have expanded the ribbon. Check for small arrow sign at right side of ribbon. If sign is down, please press that. Hope you are using Power BI Desktop, not power bi APP.
Internal error on ofc google drive data that I try to import using 'from web' to excel.500 i ternal server error or unable to connect...why is it so..pls help..
With google drive prefer Google sheet driver. Otherwise you have to use setting anyone with link. In case you want to use web driver Google Sheet- th-cam.com/video/mEq9RuuQpEs/w-d-xo.html Web Driver example : community.fabric.microsoft.com/t5/Power-Platform-Integrations/Power-Apps-Power-BI-Better-together-Write-Back-From-BI/m-p/1044976#M16
Power BI License Types: Power BI Free: Users with the free license can create and view their own reports, but they cannot share their reports with others. Power BI Pro/Power BI Premium User (PPU): Users with Pro or Premium licenses can create, view, and share reports with others. Each user/viewer, unless covered by Power BI Premium capacity, requires a Pro or Premium license to access shared reports. Power BI Premium Capacity: In Power BI Premium capacity, you can share apps with users who do not have individual licenses, making it cost-effective for widespread sharing within an organization. However, report designers (those creating the reports) in Premium capacity still require a Pro license, even if the sharing is done through Premium capacity.
This Video has been divided into 50 chapters. You can find those details into description. This short, list all the 100 topics of this video th-cam.com/users/shortsT0f4Cu6lEro
Make sure you have expanded the ribbon. Check for small arrow sign at right side of ribbon. If sign is down, please press that. Hope you are using Power BI Desktop, not power bi APP.
Hi Amit, Just started watching this video I had one question is this video cover only basic power bi or post watching this I will be able to make a good dashboard?
This video covers most of the visuals, DAX, and Power Query fundamentals. You should be able to create reports/dashboards in Power BI after watching it. The video focuses on the key concepts that will help you do so. There is a newer version of this video. There is a new version as a course, but the free version has been stopped for now - biworld.graphy.com/courses/Power-BI-Full-Course-64279a37e4b039e3060146e9 The paid version is available here - biworld.graphy.com/courses/Power-BI-Full-CourseEarly-Access--Pre-Recorded-6682d32c9df4111bff6a4883 But the above 11-hour video is a good starting point. You can post your questions in the comments.
Hey Amit, Thanks for prompt response Need some more info What is the duration of the paid video Additionally, before going for that, Do I need to complete this video?
Hi Amith great video. I have some questions here 1)I have to identify missing Excel tables from a folder after load into the power query. 2) I have to load an Excel file into power query but file size nearly 4 GB. 3) How to replace the header but my header is in the 3rd row. I should not drop the first 2 rows from the table Thanks in advance
For 3rd Question You have create a new step/table with Table.PromoteHeaders(Table.Combine ( {Table.LastN(_Changed_Type, Table.RowCount(_Changed_Type)-2) , Table.FirstN(_Changed_Type,2)})) Where _Changed_Type is you last step table or the table Full code. Paste in blank query in advance editor let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXIEYiNDpVidaCUjINMJiI2NwVxnkLQzSNAZImAMYoLkTcBcEyDTBaHbFMh0heqOBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]), _Changed_Type = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}), _finalTable = Table.PromoteHeaders(Table.Combine ( {Table.LastN(_Changed_Type, Table.RowCount(_Changed_Type)-2) , Table.FirstN(_Changed_Type,2)})) in _finalTable
What is issue you are facing? The flow is same what I have explained here th-cam.com/video/cN8AO3_vmlY/w-d-xo.html Usually any organization have office licenses should be able to create a user and assign Power BI Free or Pro or PPU license from Admin.microsoft.com. And user should be able to access same using app.powerbi.com
Please refer to the series Expertise Power BI 150+ Videos : th-cam.com/video/59PUFuuCrbY/w-d-xo.html and Mastering Power BI 230+ Videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Also, check out Microsoft Fabric 17 Videos -th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
Please find the drop box link, download sales data used in video: www.dropbox.com/sh/90ycq7hpmngabe9/AABR_l_4sy3SSALA_U95gIkWa?dl=0 Git Hub Link: github.com/amitchandakpbi/powerbi
Hello, I have just started learning powerBI and I faced an issue. In the latest version there is no option in the aggregate popup to calculate "show value as % of..." How can I resolve it? Without dax or queries/creating a new measure or is it this the only way now?
Seem like you are using On-Object Interaction. You can disable that from preview features. But in Oct-2023, I can see "Show Value as" -> "Percent of Total" Option on the right click . On a measure
Cumulative Cases: Cumulative Cases refer to the total number of confirmed COVID-19 cases in a particular country or region since the outbreak began. It includes all cases reported from day one up to the current date. So, for example, if a country had 100 cases on Day 1, 150 cases on Day 2, and 200 cases on Day 3, the cumulative cases on Day 3 would be 100+150+200=450. New Cases: New Cases, also known as Daily Cases or Confirmed Cases for a specific day, represent the number of newly reported COVID-19 cases on that particular day. It provides insights into the rate of infection on a daily basis. Using the same example, if the country reported 50 new cases on Day 2 and 50 new cases on Day 3, the new cases for Day 3 would be 50. Cumulative Deaths: Cumulative Deaths refer to the total number of deaths reported in a country or region due to COVID-19 since the beginning of the pandemic. It includes all deaths reported from day one up to the current date. Continuing with the previous example, if the country had 5 deaths on Day 1, 10 deaths on Day 2, and 15 deaths on Day 3, the cumulative deaths on Day 3 would be 5+10+15=30. New Deaths: New Deaths, also known as Daily Deaths, represent the number of new deaths reported in a country or region on a specific day due to COVID-19. It provides insights into the daily mortality rate. Using the same example, if the country reported 5 new deaths on Day 2 and 5 new deaths on Day 3, the new deaths for Day 3 would be 5. In summary, Cumulative Cases and Cumulative Deaths give us the total count since the beginning of the outbreak, while New Cases and New Deaths show us the daily reported numbers.
Thanks for this video, best one I have seen. I want to know if there is any way in power BI to archive the reports? Let's say data is getting loaded on a weekly basis, report will get populated with new data every week. so how to access the report that has older data? Please let me know.
Thanks. Seem like you want to build snapshots. You can check DAX append method blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/ www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/ Other way is that we create snapshot in database and use it. ------------------------ Please find 370+ videos, blogs, and files in 70+ hours of content. Get Fabricated with Microsoft Fabric, Power BI, SQL, Power Query, DAX Please Like and Share biworld.graphy.com/courses/Get-Fabricated-Learn-Microsoft-Fabric-Power-BI-SQL-Power-Query-DAX-Dataflow-Gen2-Data-Pipeline-from-Amit-Chandak-649506b9e4b06f333017b4f5
I have another question though. How do I replace data source with a new File in Power BI automatically? Every week a new flat file is generated and we need to do reporting on latest file. Please advise.
Please refer to this content as of now सीखे Power BI हिंदी में 50+ videos : th-cam.com/play/PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki.html Hindi on Demand 7 Videos - th-cam.com/play/PLPaNVDMhUXGYJM9Pgwa3tTgpu0EFb-TAG.html Live Hindi (video 5,6) - th-cam.com/video/6mj7xoT7OTo/w-d-xo.html
Hi I hope you are well. great video please keep up the good work. Dax: how can you Calculate difference between 2 values in same column based on a condition that says if the sum of the values in one field is equal to zero then give me zero else give me another field which is calculated. but I this is done by making a column where each row is calculated using the dax formulas but now I have the problem that power bi doesn't want to show the field in the matrix visual (but it shows it on a card.
If you need a variance measure M1= calculate([measure], Table[Column] = "Value1") - calculate([measure], Table[Column] = "Value2") Also, refer Compare Categorical Data Using Slicers, Compare Two Brands/Categories/Cities: th-cam.com/video/exN4nTewgbc/w-d-xo.html
Is it possible for me to send you this via email or something since I tried that and it is not working from my end@@AmitChandak Thank you for your reply God bless you.
Sure. As of now you can watch सीखे Power BI हिंदी में 60+ videos : th-cam.com/play/PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki.html Hindi on Demand 10+ Videos - th-cam.com/play/PLPaNVDMhUXGYJM9Pgwa3tTgpu0EFb-TAG.html Live Hindi (video 5,6) - th-cam.com/video/6mj7xoT7OTo/w-d-xo.html
This is for Beginner to Intermediate level. For more advance concepts you can watch the series Power BI Concepts 160+ Videos: th-cam.com/video/cAqjakPjbMU/w-d-xo.html
I think you taking about, Power BI file not excel sheet. I have show all the formula used in video. You can find pbix here -th-cam.com/users/redirect?event=comments&redir_token=QUFFLUhqbEJrZUhrbERzOXVXQkZsMEJCNHU3Ymg4N3hNUXxBQ3Jtc0tsYWRoVVI2MVVZSFZsUU1LRWgyRl8xZEI3eEVJUW5jbklwbm9kU1BTbG9jQV8xTEpoUUt0SGUyYUZvaWdsU3pYbmdtLUQtMk1tdjJNbXdwRHNXMzhQRHdDUTFGQjdvem9UTExLdVlkM3BOaW8tTS1XNA&q=https%3A%2F%2Fgithub.com%2Famitchandakpbi%2Fpowerbi%2Ftree%2Fmain%2FData%2520for%2520Learn%2520Power%2520BI%2520Full%2520Video&stzid=Ugx_HTlS0jAm1hxi10B4AaABAg.9vRfmiWNz2I9vS8ZHIRk8c In case you need something specific, let me know.
I think that shown around 6:10:32. th-cam.com/video/cN8AO3_vmlY/w-d-xo.html Right function work from end of string, and search works from start. So we subtract the search result from length. For one word city name, we do not want last name, so we return length. and length - length=0 , so we will not get last name.
This video is very helpful. I have learn power bi from this video. I have question as i wanted to publish my reports. But it is asking organization/student id...i don't have it as i took break of 4 yrs from my job, and it is not taking last organization id...bcz its disabled..so what to do in such cases? if i want to publish report and not having id?
@@AmitChandak This link doesn't create any new id...I got "Thank you for joining. You don't current qualify for a Microsoft 365 Developer Program sandbox subscription." this msg from them..
Yes, this one is for beginners to intermediate learners. For experts, you can pick and watch individual videos from the series. Expertise Power BI: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
Amit Bai, Weekday formula is not refreshing on 1st Jan 2020 (its doing sum from 30-12-2019 i.e. Week start) and Secondly, I want to compare This Year Week Day Vs Last Year Week Day, which i am trying with formula -52 in Week Rank of but result are not correct. Need your guidance on both points Pls.
This year vs last year same week day week Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAY)) Also check Power BI - Week on Week and WTD medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3 community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123 th-cam.com/video/pnAesWxYgJ8/w-d-xo.html Time Intelligence, Part of learn Power BI th-cam.com/video/cN8AO3_vmlY/w-d-xo.html
Hi Sir, I watched all your videos on master power bi series. I have one doubt. How to get sales value based on sales date and delivery date ? Thanks in advance
Join both of them with date table, one join will be inactive, say for delivery date. You can create a measure with userelationship to use that join example calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Sales'[Delivery Date], 'Date'[Date])) refer Power BI: HR Analytics - Employees as on Date : th-cam.com/video/e6Y-l_JtCq4/w-d-xo.html community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970 Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: th-cam.com/video/fvgcx8QLqZU/w-d-xo.html
Hi @laxmanreddy2051 , This video will give you basic concepts. My Advice would be to watch selective videos from Expertise Power BI: th-cam.com/video/59PUFuuCrbY/w-d-xo.html And Watch Interview Questions: Power BI Interview Questions series: th-cam.com/video/vvFGAAbds1k/w-d-xo.html Blogs: Power BI Interview Part 1: amitchandak.medium.com/power-bi-interview-questions-part-1-4982de3be327 Power BI Interview Part 2: amitchandak.medium.com/power-bi-interview-questions-part-2-de5c7b16db84
You should be able to clear a beginner interview with that. But I would recommend, Please watch this video + Selective video from Mastering Power BI: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Expertise in Power BI: th-cam.com/video/59PUFuuCrbY/w-d-xo.html That should be helpful for a Power BI interview. In case you need to know the basics of SQL, please check out the SQL series: th-cam.com/play/PLPaNVDMhUXGblXMYDB1P46cBhwPXRVgiD.html Join the Telegram Channel - I will post Questions and quizzes t.me/amitchandakda You can ping me on Linkedin
Check if alternate videos DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar th-cam.com/video/IsfCMzjKTQ0/w-d-xo.html or Beginner series from this video onward th-cam.com/video/Qt0TM-4H09U/w-d-xo.html
It will give you the necessary start for Power BI. You can further enhance your skills using Mastering Power BI: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Expertise Power BI: th-cam.com/video/59PUFuuCrbY/w-d-xo.html Refer: medium.com/@amitchandak/structure-your-power-bi-learning-on-my-youtube-channel-1f745aa6c84e I plan to start one, will announce on web.telegram.org/k/#@amitchandakda
Hindi ka ek bada Video pending hain Per series hai सीखे Power BI हिंदी में 50+ videos : th-cam.com/play/PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki.html Hindi on Demand 7 Videos - th-cam.com/play/PLPaNVDMhUXGYJM9Pgwa3tTgpu0EFb-TAG.html Live Hindi (video 5,6) - th-cam.com/video/6mj7xoT7OTo/w-d-xo.html
New Version Available: If you want to learn Power BI from the ground up-covering everything from basic data modeling to advanced DAX and real-world analytics-be sure to explore my 20-hour Masterclass, packed with 150+ essential topics to elevate your data analytics and business intelligence skills.
th-cam.com/video/cyWVzAQF9YU/w-d-xo.html
great explanation of all features of PowerBI
Thanks
Great to see this video, Thanks for sharing
Glad you enjoyed it
@@AmitChandaki
Kkkkkkk
Kik
🙏 Thank You for 100,000 Views & 2000 Likes! 🎉
I want to express my heartfelt thanks to everyone who took the time to view this video, designed for beginners and intermediates. This TH-cam video was launched just ten months ago and has now surpassed 100,000 views, with 2000 kudos from wonderful viewers like yourself. Your constant support and active engagement truly mean the world to me.
Do you do consulting work to develop a SharePoint Intranet site with Power BI (if needed) for a fire department?
I have started to learn power bi trying to download sales data used in video, but not able to download it...
After completing the video, what I have realized is that one should already have some beginner-level proficiency in Power BI to understand the concepts explained in this video. Overall, well-structured video and covers many important concepts.
Absolutely the BEST Power BI course I've ever come across! 👏🔥 The content is incredibly well-structured, and the concepts are clearly explained. Perfect for anyone looking to master Power BI. Highly recommended! 💡💻.
Thank you for the kind words! I'm glad you found the course helpful.
Ohh OMG! I missed your notification.
Amazing Sir for your great contribution. This video will help a lot to the learners.
So nice of you. Thanks 🙏 for your support.
Sir, amazing sir.
Thank you very much for sharing this video. I've taken a Power BI course during my Masters degree in analytics and been working with Power BI for 9 months now. Yet, I want to mention that this Power BI tutorial has so much value.
Thank you 🙏 so much for your kind words and support! I'm truly grateful for your feedback. It's wonderful to hear that even with your experience and background in Power BI, you found value in this tutorial
I have reorganized my 370+ videos, blogs, and files in 70+ hours of content on Microsoft Fabric, Power BI, and SQL and put it into a course on an LMS.
Free as of now
biworld.graphy.com/courses/Get-Fabricated-Learn-Microsoft-Fabric-Power-BI-SQL-Power-Query-DAX-Dataflow-Gen2-Data-Pipeline-from-Amit-Chandak-649506b9e4b06f333017b4f5
@@AmitChandak ofcourse!
Thank you for sharing the link, I will check it 👍🏻
Hi Amit, I have been following you on various platforms and the simple language and examples makes your videos highly important and popular.
I have just 1 request if you can also share the pbix files that you use on any particular topic, it will be a great help.
Many Thanks 😊
very nice video for creating impactful visualization report ✌🤘👍
Thanks 🙏
Most all inclusive power bi video ever!
Since one and half years there are so many different types of TH-cam channels. But Amit You explain very well. Thanks a lot it will help a lot.
So nice of you
@@AmitChandak Thank you Amit , Please explain how to understand or Analyse the data. Canvas setting also. Please
Hindi language me bhi bana do sir@@AmitChandak
Wowww
Really it's great for beginners
I love you from Bihar ❤️
Great explanation Amit. Perfect for beginners to master Power BI fundamentals and build a dynamic dashboards. Highly recommended for beginners.
Thanks for your kind words!
this tutorial is very helpful, amidst an ocean of content present related to power BI ,this one stands out in clarifying the threadbare details of the Power Bi
Glad it was helpful! Thanks 🙏
Hope you will likes the other series too
Mastering Power BI 230+ videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Power BI Concepts 160+ Videos: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
Mastering Microsoft Fabric 35+ Videos: th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
Very informative. Waiting for more videos.
Thank you for your kind words! I'm glad you found my video informative.
You can check out more video from other series
Mastering Power BI: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Expertise Power BI: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
Mastering Microsoft Fabric: th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
Power BI Interview Questions Part 1 - 40 Questions: th-cam.com/video/vvFGAAbds1k/w-d-xo.html
DAX vs SQL: th-cam.com/video/WlvQ_SGy4iA/w-d-xo.html
Tableau Vs Power BI: th-cam.com/video/tAmg00Wf_cw/w-d-xo.html
Power BI Decoding Direct Query: th-cam.com/play/PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA.html
SQL - th-cam.com/video/ThCZYuYAbnY/w-d-xo.html
Your explanation is too clear and very easy to understand. I catch up most of the things that you shared. Thanks!
Thank you so much for your appreciation. It motivates me to do better in the future. 🙏
You are doing really great teaching Amit. You are an expert and give free education. Heartiest thanks!
So nice of you. Thanks 🙏
Simply Awesome!
Thank you! Cheers!
Best compilation of all basica
I'm glad you enjoyed the compilation! If you found it helpful, feel free to share it with others who might benefit from it too. 🙏
Thank you so much sir
Most welcome
You are So Humble example is this video, take lots of your time but you make it for us Lots of Love Amit Bhai ❤🎉😊
awesome
Thanks Amit.
Thanks.
Thank you
You're welcome
After follow him from LinkedIn now auto subscribe his TH-cam channel..thank you sir
Thanks 🙏
for scatterplot formatting how is selected working to get average
It seems like you are discussing the color measure. In this case, each point on the scatter plot represents a row, which in turn represents a city and provides a row-specific value. To calculate the overall average, we need an overall total or average. This can be done by using either the "all" or "allselected" functions in the measure. We prefer to use the "allselected" function because it allows us to ignore the row context without removing the filter context.
What is the difference between all and allselected in dax/power bi? - th-cam.com/video/FTpc5IdT0Og/w-d-xo.html
Great video sir ❤️
Thanks a ton. So Nice of You.
Thanks for this tutorial and rhe timestamp Amit . This video covers everything that is needed .. Looking forward to more of your videos on some dax scenarios
Thanks a ton. 🙏
Hope you will like these series
Mastering Power BI 230+ videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Power BI Concepts 160+ Videos: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
Mastering Microsoft Fabric 35+ Videos: th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
🙏 Thank You for 50,000 Views & 1000 Kudos to 11-hour video! 🎉
My sincere gratitude goes out to those who took the time to watch my video, especially the 11-hour full video for beginners and intermediates. This TH-cam video was launched just five months ago, has reached over 50,000 views, and received 1000 kudos from amazing viewers like you. I am extremely grateful for your continuous support and engagement.
Your response has truly touched my heart and motivated me to continue creating valuable content to share knowledge with you. I am committed to delivering insightful and informative videos that empower you in your data analytics journey.
I would like to extend my heartfelt gratitude to each and every one of you who watched, liked, commented, and shared my video. Your engagement and encouragement mean the world to me.
If you haven't watched the video yet, I invite you to join the thousands of viewers who have found value in it. Simply click on the link below and embark on an exciting learning experience.
Complete Power BI Video 11Hour: th-cam.com/video/cN8AO3_vmlY/w-d-xo.html
Thank you again for taking the time to watch my video. Stay tuned for more exciting content, tutorials, and insights that will help you excel in the world of data analytics.
😮
Thanks Amit for this am currently an hour into the training and I all I can say is thank you for taking your time to explain I am following the training and practicing at same time. When am done probably by tomorrow will drop my final review.
Thanks so much! I'll be looking forward to your final review. There's also a newer version available, and I'd be happy to give you access if you're interested biworld.graphy.com/courses/Power-BI-Full-Course-64279a37e4b039e3060146e9
If you need that, ping me on LinkedIn, I will enable the Enroll button- www.linkedin.com/in/amitchandak78/
2:02:42
-Love and enormous respect from Dhaka, Bangladesh Sir.
Thanks a lot. Appreciate your support to the channel 🙏
Please convert to your old religious
your teaching style is very good and simple.
Thanks David.
Also, Please check videos on newly released Microsoft Fabric 17 Videos-
th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
Mastering Power BI 200+ Videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Expertise Power BI 150+ Videos: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
DAX vs SQL: th-cam.com/video/WlvQ_SGy4iA/w-d-xo.html
Tableau Vs Power BI: th-cam.com/video/tAmg00Wf_cw/w-d-xo.html
Really amit you did a fantastic job. No words for your explanation. You taught even small small things which is really helpful.... you deserve a more than one million likes
Even I have seen only 4 hours video and literally iam glad .
Thank you so much for your kind words and encouragement! It's truly rewarding to know that the video has been helpful and appreciated. I'm especially glad to hear that the detailed explanations were useful. If you have any suggestions for future topics or specific areas you'd like to learn more about, please feel free to share. Your support and engagement are incredibly motivating. Remember, every like, share, and comment helps others find and benefit from this resource, so your million-like wish really means a lot! 🌟 Happy learning and do stay connected for more content
Once done, you can pick and choose topics from these two series
Mastering Power BI 230+ videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Power BI Concepts 160+ Videos: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
Thank you so much sir your explanation is easy to understand keep going on sir and please post all those videos related to power bi and sql sir 🙏🙏☺☺❣️
Thanks 🙏.
Hope you will enjoy these series
Mastering Power BI 230+ videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Power BI Concepts 160+ Videos: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
Mastering Microsoft Fabric 40+ Videos: th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
Additional content on the channel
Mastering Microsoft Fabric in Hindi: th-cam.com/video/6aduOToIwtg/w-d-xo.html
Power BI Interview Questions Part 1 - 40 Questions: th-cam.com/video/vvFGAAbds1k/w-d-xo.html
DAX vs SQL: th-cam.com/video/WlvQ_SGy4iA/w-d-xo.html
Tableau Vs Power BI:
th-cam.com/video/tAmg00Wf_cw/w-d-xo.html
Power BI Decoding Direct Query: th-cam.com/play/PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA.html
सीखे Power BI हिंदी में: th-cam.com/play/PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki.html
Concepts of Business Intelligence: th-cam.com/video/bmhGLoT-_a8/w-d-xo.html
SQL - th-cam.com/video/ThCZYuYAbnY/w-d-xo.html
Tableau - th-cam.com/play/PLPaNVDMhUXGb5DWmhtg84df9AalKbptis.html
Tableau- Hindi -th-cam.com/play/PLPaNVDMhUXGaYGdI0-30-kvR1eqVObHTl.html
Power BI Hindi On Demand - th-cam.com/video/hgLIwUZq8zo/w-d-xo.html
2 and a half hours in, already enriched my brain to holy amounts thx G.
Thanks, Hope you like other videos and series too
Mastering Power BI 230+ videos:
th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Power BI Concepts 180+ Videos:
th-cam.com/video/cAqjakPjbMU/w-d-xo.html
Mastering Microsoft Fabric 50+ Videos:
th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
Sir can you share link of other video which you are referring for advance level of power Bi at the start of the video ?
Please refer to this series
Power BI Concepts 180+ Videos:
th-cam.com/video/cAqjakPjbMU/w-d-xo.html
Also, refer how to break a file, in first few video of the series
Mastering Power BI 230+ videos:
th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Excelent
Thanks
subscribed done love from Mumbai
Thanks.
Also, Please check videos on newly released Microsoft Fabric 17 Videos-
th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
Mastering Power BI 200+ Videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Expertise Power BI 150+ Videos: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
DAX vs SQL: th-cam.com/video/WlvQ_SGy4iA/w-d-xo.html
Tableau Vs Power BI: th-cam.com/video/tAmg00Wf_cw/w-d-xo.html
SIR,why we did LEN([CITY])+1 at 06:09:52 ,why we r adding 1?
For city names without spaces, the function will return the value of the fourth parameter during a search. Typically, we use 0 as the fourth parameter. However, in this scenario, we want to return the length of the city name.
Now, if there is a white space in a city name, such as "New York," the function will return 4. However, we only want to return 3 characters, as we don't want the white space at the end of the first name. In other words, we need to subtract 1.
However, this subtraction of -1 will affect city names without spaces, as it would reduce the character count by 1. That's why we added one to the length of the city name when there are no spaces.
thanks sir got it@@AmitChandak
Sir i complete this video now I want start my first project in covid 19 so i have one question, without cleaning the covid data means without removing the null values in new death and new column can i start my build report? Sir please answer it🙏🏻☺
Yes, you can.
Additionally, you can consider using a date table like we do in HR, joining with both dates and using USERELATIONSHIP for inactive joins.
Power BI: HR Analytics - Employees as on Date : th-cam.com/video/e6Y-l_JtCq4/w-d-xo.html
community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: th-cam.com/video/fvgcx8QLqZU/w-d-xo.html
Thank you so much sir 🙏🏻🙏🏻😊 wish to god give you lot of success🏆💪
Sir , have recently joined your channel, have watched your many solutions over power bi community post, which has helped me a lot. will watch this video in my weekends and will share the feedback, ❤❤
Thanks, Looking forward to it.
You can refer to videos and playlists
Complete Power BI in one Video: th-cam.com/video/cN8AO3_vmlY/w-d-xo.html
Mastering Power BI: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Expertise Power BI: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
DAX vs SQL: th-cam.com/video/WlvQ_SGy4iA/w-d-xo.html
Tableau Vs Power BI: th-cam.com/video/tAmg00Wf_cw/w-d-xo.html
Power BI Decoding Direct Query: th-cam.com/play/PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA.html
@@AmitChandak Thanks for the sort listing the videos sir, really appreciate it 😃
Kindly make video on interview how to krack interview and what type topic to be cover fore interview
The first set of 40 Interview questions coming soon as a blog, playlist, and single video. So stay tuned.
Thanks for support to the channel 🙏
@@AmitChandak thank sir
This is blog link: amitchandak.medium.com/power-bi-interview-questions-part-1-4982de3be327
Videos I am uploading - They will part of this podcast - th-cam.com/play/PLPaNVDMhUXGbUzSOKy3A15J5wAgQedQtl.html
Sir aap Power Bi community pe jyada solution provide krte ho na?
Maine apka naam waha pe bahut baar dekha hu.
हाँ , पावर बी कम्युनिटी(Power Bi Community) पर काफ़ी सोलूशन्स देता हूँ
@@AmitChandak you are amazing sir
If we are not having organisation mailid. How sir?
Refer: foresightbi.com.ng/microsoft-power-bi/how-to-use-power-bi-without-work-or-school-email/
Hii sir, I do not have org id, so i created an id and, while importing map id 1:01:18
, it says to contact admin, is there any solution for it?
Hi @swatishankar-ww2vl,
Thank you for contacting us. Please follow this link to start a Power BI Pro trial:
github.com/MicrosoftDocs/powerbi-docs/blob/live/powerbi-docs/admin/service-admin-signing-up-for-power-bi-with-a-new-office-365-trial.md
Thanks,
Amit
thank you for the reply @@AmitChandak
thank you sir, it was good learning with this session can you help me to stream real time data streaming in power bi services from sql server ?
In case of Regular Power BI
1. Direct Connection
2. We need use Azure Event stream
Do you want Realtime data update
HI couldn't download the data from Github
any suggestions
Please try DropBox Link - www.dropbox.com/sh/90ycq7hpmngabe9/AABR_l_4sy3SSALA_U95gIkWa?dl=0
this video is really nice, thanks for uploading.
I have one question: Can I get Top % with Windows function ?
Thanks. Please refer
Power BI Window function- Pareto Analysis, 80% of sales, Order by on Measure: th-cam.com/video/UVxiLc_AzSs/w-d-xo.html
Sir,
what is the diffrenece between trailing year and LYTD.
when i am adding them separtely on card the value for LYTD is lesser than the value of trailing year. what is the reason behind it... i am not able to understand.
plz reply ASAP!!!
LYTD is last year till date. Trailing year is one year before data. If you select month Feb 2020. LYTD will be jan and Feb 2019. While trailing will be Fab 2019. On card visual, if there is no date in context. Then trailing is complete data 1 year before. While LYTD will be based on last date of date table.
thank you sir
but sir, if we have 2018,19,and2020 data then trailing year will give us 2 years of data but LYTD is also giving 2 years of data if we click on 2019 it will give data of 2018
if we click on 2020 it will give the data of 2019
so it is also giving us 2 years of data. but th value on card is totally different. so sir what is the reason behind it i am not able to figure it out!!! @@AmitChandak
when you do not have a date in context, filter, or row(visual), like card visual, and no filter/slicer on the page. Then trailing year is the sum last -1 year of the whole data. But if you select 2020 in the slicer or it is row context, then you should get 2019. if 6 rules are followed
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI:th-cam.com/video/OBf0rjpp5Hw/w-d-xo.html
amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
th-cam.com/users/shortsown-TbwO95g
Trailing year should give one-year back data for the year in a context filter or row.
With month year it will give same month last year
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))
yes sir got it that trailing year is minus 1 year of all data but LYTD will also give the data of 2 year right???@@AmitChandak
16:28 Why is Vizualisation missing in my case? I have Filters and Fields, but no vizualisations. I have Graphs in the "Home tab - Insert". Maybe it does not make much difference, but is easier to follow the tutorial.
This is because of on-object interactions, which is enabled by default now. You can disable that as of now from File-> Options and settings -> Options -> Preview Features
th-cam.com/video/IxeaaSr-TXo/w-d-xo.html
@@AmitChandak Thank you, sir!
Hi sir, I cannot see the column names after loading the covid csv file into power bi. only it is showing column1, column2 ...,, how to solve it?
Open Power Query and mark first row as header.
Discussed in this video after
Power BI: Power Query Functions one must know
: th-cam.com/video/cN8AO3_vmlY/w-d-xo.html
@@AmitChandak Thank you.
Hello Sir,
After PowerBI, should we learn PowerApp and PowerAutomate?
Power App is a good option if you enjoy creating apps and user interfaces. Otherwise Power Automate. Power Automate is a better option as you continue to optimize the data process
@@AmitChandak okay Sir. Thank you
Are you going to start Power App and Power Automate series?
Amit Brother i am not getting Column Tool Option on the Top of Bar in Power BI, Pls Advice
Make sure you have expanded the ribbon. Check for small arrow sign at right side of ribbon. If sign is down, please press that.
Hope you are using Power BI Desktop, not power bi APP.
Internal error on ofc google drive data that I try to import using 'from web' to excel.500 i ternal server error or unable to connect...why is it so..pls help..
With google drive prefer Google sheet driver. Otherwise you have to use setting anyone with link. In case you want to use web driver
Google Sheet- th-cam.com/video/mEq9RuuQpEs/w-d-xo.html
Web Driver example : community.fabric.microsoft.com/t5/Power-Platform-Integrations/Power-Apps-Power-BI-Better-together-Write-Back-From-BI/m-p/1044976#M16
Sir if We have any power BI licence so end users need any licence to show report
Power BI License Types:
Power BI Free: Users with the free license can create and view their own reports, but they cannot share their reports with others.
Power BI Pro/Power BI Premium User (PPU): Users with Pro or Premium licenses can create, view, and share reports with others. Each user/viewer, unless covered by Power BI Premium capacity, requires a Pro or Premium license to access shared reports.
Power BI Premium Capacity:
In Power BI Premium capacity, you can share apps with users who do not have individual licenses, making it cost-effective for widespread sharing within an organization.
However, report designers (those creating the reports) in Premium capacity still require a Pro license, even if the sharing is done through Premium capacity.
Any course outline and syllabus for this course please ?
This Video has been divided into 50 chapters. You can find those details into description.
This short, list all the 100 topics of this video
th-cam.com/users/shortsT0f4Cu6lEro
Amit Brother i am not getting Column Tool Option On the Power BI Top Bar, Pls Advice
Make sure you have expanded the ribbon. Check for small arrow sign at right side of ribbon. If sign is down, please press that.
Hope you are using Power BI Desktop, not power bi APP.
Thanks Amit Brother @@AmitChandak
Hi Amit,
Just started watching this video
I had one question is this video cover only basic power bi or post watching this I will be able to make a good dashboard?
This video covers most of the visuals, DAX, and Power Query fundamentals. You should be able to create reports/dashboards in Power BI after watching it. The video focuses on the key concepts that will help you do so. There is a newer version of this video.
There is a new version as a course, but the free version has been stopped for now - biworld.graphy.com/courses/Power-BI-Full-Course-64279a37e4b039e3060146e9
The paid version is available here - biworld.graphy.com/courses/Power-BI-Full-CourseEarly-Access--Pre-Recorded-6682d32c9df4111bff6a4883
But the above 11-hour video is a good starting point. You can post your questions in the comments.
Hey Amit,
Thanks for prompt response
Need some more info
What is the duration of the paid video
Additionally, before going for that, Do I need to complete this video?
Hey,
Shall I complete this before jumping to paid video
Need your response, where to begin?
I facing challeges with dax in realtime environment.unable to build logics. Can you please help me.
Please share issues you are facing
Hi Amith great video.
I have some questions here
1)I have to identify missing Excel tables from a folder after load into the power query.
2) I have to load an Excel file into power query but file size nearly 4 GB.
3) How to replace the header but my header is in the 3rd row. I should not drop the first 2 rows from the table
Thanks in advance
For 3rd Question
You have create a new step/table with
Table.PromoteHeaders(Table.Combine
( {Table.LastN(_Changed_Type, Table.RowCount(_Changed_Type)-2)
, Table.FirstN(_Changed_Type,2)}))
Where _Changed_Type is you last step table or the table
Full code. Paste in blank query in advance editor
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXIEYiNDpVidaCUjINMJiI2NwVxnkLQzSNAZImAMYoLkTcBcEyDTBaHbFMh0heqOBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]),
_Changed_Type = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}),
_finalTable = Table.PromoteHeaders(Table.Combine
( {Table.LastN(_Changed_Type, Table.RowCount(_Changed_Type)-2)
, Table.FirstN(_Changed_Type,2)}))
in
_finalTable
@@AmitChandak
Thank you very much. If possible can you make a video in your free time?
Why i am not able to download the files from github?? Showing error
Please try this Dropbox link - www.dropbox.com/sh/90ycq7hpmngabe9/AABR_l_4sy3SSALA_U95gIkWa?dl=0
not able to download gitgub file sale video ,Git hub is showing error that will not show this big file
Try to copy it from Drop box - www.dropbox.com/sh/90ycq7hpmngabe9/AABR_l_4sy3SSALA_U95gIkWa?dl=0
Thank you so much ,your reply helped me to move ahead @@AmitChandak
Sir can u plz make a silimar video for Tableau 2023 also?
Sure , I will try. As of now you can refer old series th-cam.com/play/PLPaNVDMhUXGb5DWmhtg84df9AalKbptis.html
Hi
am facing issues while creating ID and login could you please help or could you share link of the video that how to create ID ?
What is issue you are facing? The flow is same what I have explained here
th-cam.com/video/cN8AO3_vmlY/w-d-xo.html
Usually any organization have office licenses should be able to create a user and assign Power BI Free or Pro or PPU license from Admin.microsoft.com. And user should be able to access same using app.powerbi.com
Thank you got the acces
@@AmitChandak
Thank 🙏 you for the update.
I'm glad to hear that you now have access to Power BI. I hope you're enjoying it.
Very nice ....can you make how can we use AI in power bi
Will try
can you make advanced course on power bi
Please refer to the series
Expertise Power BI 150+ Videos : th-cam.com/video/59PUFuuCrbY/w-d-xo.html
and
Mastering Power BI 230+ Videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Also, check out
Microsoft Fabric 17 Videos -th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
sales file not downloading
pls help?
Please find the drop box link, download sales data used in video: www.dropbox.com/sh/90ycq7hpmngabe9/AABR_l_4sy3SSALA_U95gIkWa?dl=0
Git Hub Link: github.com/amitchandakpbi/powerbi
Hi Sir, Thank you so much for sharing this video. Is It sufficient for data analyst?
It should be a good starting point for that. You can watch other videos to improve skills
Thank you Amit for sharing the content. The way you explain the concepts is flawless i enjoyed the content 🤩🤩
Thank you once again 👍
My pleasure 😊. Thanks 🙏
Hello Amit, pls let me know if you take online interactive classes also , want to enroll for power bi course
I will soon announce a new live classroom course. Enroll for any free course on given. I will share email - biworld.graphy.com/s/store
Hello,
I have just started learning powerBI and I faced an issue. In the latest version there is no option in the aggregate popup to calculate "show value as % of..." How can I resolve it?
Without dax or queries/creating a new measure or is it this the only way now?
Seem like you are using On-Object Interaction. You can disable that from preview features.
But in Oct-2023, I can see "Show Value as" -> "Percent of Total" Option on the right click . On a measure
@@AmitChandak thanks a lot🙌
Hi Amit, I have question what is the different New cases, New Deaths and Cumulative cases and deaths.. Thank you
Cumulative Cases: Cumulative Cases refer to the total number of confirmed COVID-19 cases in a particular country or region since the outbreak began. It includes all cases reported from day one up to the current date. So, for example, if a country had 100 cases on Day 1, 150 cases on Day 2, and 200 cases on Day 3, the cumulative cases on Day 3 would be 100+150+200=450.
New Cases: New Cases, also known as Daily Cases or Confirmed Cases for a specific day, represent the number of newly reported COVID-19 cases on that particular day. It provides insights into the rate of infection on a daily basis. Using the same example, if the country reported 50 new cases on Day 2 and 50 new cases on Day 3, the new cases for Day 3 would be 50.
Cumulative Deaths: Cumulative Deaths refer to the total number of deaths reported in a country or region due to COVID-19 since the beginning of the pandemic. It includes all deaths reported from day one up to the current date. Continuing with the previous example, if the country had 5 deaths on Day 1, 10 deaths on Day 2, and 15 deaths on Day 3, the cumulative deaths on Day 3 would be 5+10+15=30.
New Deaths: New Deaths, also known as Daily Deaths, represent the number of new deaths reported in a country or region on a specific day due to COVID-19. It provides insights into the daily mortality rate. Using the same example, if the country reported 5 new deaths on Day 2 and 5 new deaths on Day 3, the new deaths for Day 3 would be 5.
In summary, Cumulative Cases and Cumulative Deaths give us the total count since the beginning of the outbreak, while New Cases and New Deaths show us the daily reported numbers.
@@AmitChandak Thank You so much
@@AmitChandak Amit one more question if death percentage shown mean how we can show ??
Thanks for this video, best one I have seen.
I want to know if there is any way in power BI to archive the reports? Let's say data is getting loaded on a weekly basis, report will get populated with new data every week. so how to access the report that has older data? Please let me know.
Thanks. Seem like you want to build snapshots. You can check DAX append method
blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
Other way is that we create snapshot in database and use it.
------------------------
Please find 370+ videos, blogs, and files in 70+ hours of content. Get Fabricated with Microsoft Fabric, Power BI, SQL, Power Query, DAX
Please Like and Share
biworld.graphy.com/courses/Get-Fabricated-Learn-Microsoft-Fabric-Power-BI-SQL-Power-Query-DAX-Dataflow-Gen2-Data-Pipeline-from-Amit-Chandak-649506b9e4b06f333017b4f5
Thanks for the quick response. Will check these out. Appreciate it 👍
I have another question though.
How do I replace data source with a new File in Power BI automatically? Every week a new flat file is generated and we need to do reporting on latest file. Please advise.
Sir hind me pura power bi playlist banayena
Please refer to this content as of now
सीखे Power BI हिंदी में 50+ videos : th-cam.com/play/PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki.html
Hindi on Demand 7 Videos - th-cam.com/play/PLPaNVDMhUXGYJM9Pgwa3tTgpu0EFb-TAG.html
Live Hindi (video 5,6) - th-cam.com/video/6mj7xoT7OTo/w-d-xo.html
@@AmitChandak thank u sir
In the recent update the field and visualization pane is not visible could you help to sort it out?
Under Options and Settings-> Options -> Preview feature disable on-object interactions. That will give you old view.
Hi I hope you are well. great video please keep up the good work.
Dax: how can you Calculate difference between 2 values in same column based on a condition that says if the sum of the values in one field is equal to zero then give me zero else give me another field which is calculated. but I this is done by making a column where each row is calculated using the dax formulas but now I have the problem that power bi doesn't want to show the field in the matrix visual (but it shows it on a card.
If you need a variance measure
M1= calculate([measure], Table[Column] = "Value1") - calculate([measure], Table[Column] = "Value2")
Also, refer
Compare Categorical Data Using Slicers, Compare Two Brands/Categories/Cities: th-cam.com/video/exN4nTewgbc/w-d-xo.html
Is it possible for me to send you this via email or something since I tried that and it is not working from my end@@AmitChandak Thank you for your reply God bless you.
Sir pls make one video using hindi language .
Sure.
As of now you can watch
सीखे Power BI हिंदी में 60+ videos : th-cam.com/play/PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki.html
Hindi on Demand 10+ Videos - th-cam.com/play/PLPaNVDMhUXGYJM9Pgwa3tTgpu0EFb-TAG.html
Live Hindi (video 5,6) - th-cam.com/video/6mj7xoT7OTo/w-d-xo.html
Sir power bi service ki video Hindi main kab tak aayegi ??
Planning to share soon
@@AmitChandak Thanks Sir
@avinayakchoudhary4172 Check th-cam.com/video/H7_mncglJ9M/w-d-xo.html
Sir, can you share the sales excel data file
Please find the file: github.com/amitchandakpbi/powerbi/blob/main/Sales%20Data%20Used%20in%20Video.xlsx
Is this beginner to advanced or only beginner level course?
This is for Beginner to Intermediate level. For more advance concepts you can watch the series
Power BI Concepts 160+ Videos:
th-cam.com/video/cAqjakPjbMU/w-d-xo.html
I saw lots of formula in the sheet. How can I learn the formula.
I think you taking about, Power BI file not excel sheet. I have show all the formula used in video.
You can find pbix here -th-cam.com/users/redirect?event=comments&redir_token=QUFFLUhqbEJrZUhrbERzOXVXQkZsMEJCNHU3Ymg4N3hNUXxBQ3Jtc0tsYWRoVVI2MVVZSFZsUU1LRWgyRl8xZEI3eEVJUW5jbklwbm9kU1BTbG9jQV8xTEpoUUt0SGUyYUZvaWdsU3pYbmdtLUQtMk1tdjJNbXdwRHNXMzhQRHdDUTFGQjdvem9UTExLdVlkM3BOaW8tTS1XNA&q=https%3A%2F%2Fgithub.com%2Famitchandakpbi%2Fpowerbi%2Ftree%2Fmain%2FData%2520for%2520Learn%2520Power%2520BI%2520Full%2520Video&stzid=Ugx_HTlS0jAm1hxi10B4AaABAg.9vRfmiWNz2I9vS8ZHIRk8c
In case you need something specific, let me know.
I am a beginner.. Is this cover all basics sir?
Yes, it is. Let me know, if need additional information.
AT 6:12:24 ,u didnt tell us how to get last name of the city??
plz answer this
I think that shown around 6:10:32.
th-cam.com/video/cN8AO3_vmlY/w-d-xo.html
Right function work from end of string, and search works from start. So we subtract the search result from length.
For one word city name, we do not want last name, so we return length.
and length - length=0 , so we will not get last name.
This video is very helpful. I have learn power bi from this video. I have question as i wanted to publish my reports. But it is asking organization/student id...i don't have it as i took break of 4 yrs from my job, and it is not taking last organization id...bcz its disabled..so what to do in such cases? if i want to publish report and not having id?
Check this out - foresightbi.com.ng/microsoft-power-bi/how-to-use-power-bi-without-work-or-school-email/
@@AmitChandak sure. Thanks a ton for quick reply
@@AmitChandak This link doesn't create any new id...I got "Thank you for joining. You don't current qualify for a Microsoft 365 Developer Program sandbox subscription." this msg from them..
I need full power bi course how much it cost
Thank you for providing the dataset
Thank you for your comment!
Hii sir no doubt this is amazing lecture. But i want notes of this lecture using which we can quick revise so can you please provide us.
Hi Vivek,
I do not have notes. You can get the pbix from
github.com/amitchandakpbi/powerbi/tree/main/Data%20for%20Learn%20Power%20BI%20Full%20Video
unable to download the file from github
@guptaparas1994 , Please use drop box link : www.dropbox.com/sh/90ycq7hpmngabe9/AABR_l_4sy3SSALA_U95gIkWa?dl=0
@@AmitChandak thnx sir
This course is better for begginer?
Yes, this one is for beginners to intermediate learners.
For experts, you can pick and watch individual videos from the series.
Expertise Power BI: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
Amit Bai, Weekday formula is not refreshing on 1st Jan 2020 (its doing sum from 30-12-2019 i.e. Week start) and Secondly, I want to compare This Year Week Day Vs Last Year Week Day, which i am trying with formula -52 in Week Rank of but result are not correct. Need your guidance on both points Pls.
This year vs last year same week day
week Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAY))
Also check
Power BI - Week on Week and WTD
medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
th-cam.com/video/pnAesWxYgJ8/w-d-xo.html
Time Intelligence, Part of learn Power BI th-cam.com/video/cN8AO3_vmlY/w-d-xo.html
@@AmitChandak Thank you Amit Bai
Hi Sir, I watched all your videos on master power bi series. I have one doubt. How to get sales value based on sales date and delivery date ? Thanks in advance
Join both of them with date table, one join will be inactive, say for delivery date. You can create a measure with userelationship to use that join
example
calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Sales'[Delivery Date], 'Date'[Date]))
refer
Power BI: HR Analytics - Employees as on Date : th-cam.com/video/e6Y-l_JtCq4/w-d-xo.html
community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: th-cam.com/video/fvgcx8QLqZU/w-d-xo.html
@@AmitChandak Thanks a lot for replying sir. means a lot. Your playlsts really helping me progrss in power bi journey
2:18:00
Can we get job in power bi with this one video ...Please can you reply amith
Hi @laxmanreddy2051 , This video will give you basic concepts. My Advice would be to watch selective videos from
Expertise Power BI: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
And Watch Interview Questions:
Power BI Interview Questions series:
th-cam.com/video/vvFGAAbds1k/w-d-xo.html
Blogs:
Power BI Interview Part 1: amitchandak.medium.com/power-bi-interview-questions-part-1-4982de3be327
Power BI Interview Part 2: amitchandak.medium.com/power-bi-interview-questions-part-2-de5c7b16db84
Is power bi enough to get job or required some another skills with it???
You should be able to clear a beginner interview with that. But I would recommend,
Please watch this video +
Selective video from
Mastering Power BI: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Expertise in Power BI: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
That should be helpful for a Power BI interview.
In case you need to know the basics of SQL, please check out the SQL series: th-cam.com/play/PLPaNVDMhUXGblXMYDB1P46cBhwPXRVgiD.html
Join the Telegram Channel - I will post Questions and quizzes
t.me/amitchandakda
You can ping me on Linkedin
amazing vdo totally understandable but the portion between 5:16:04 to 5:53:54 ,unable to understand
plz help me in this if u can
thankyou😊
Check if alternate videos
DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
th-cam.com/video/IsfCMzjKTQ0/w-d-xo.html
or Beginner series from this video onward
th-cam.com/video/Qt0TM-4H09U/w-d-xo.html
Love the outfits .. plz share links
Hi sir can you provide sql class also plzz
Please check if this playlist can help
SQL- Learn with SQL Server
th-cam.com/play/PLPaNVDMhUXGblXMYDB1P46cBhwPXRVgiD.html
is this video enough for complete power bi? do you provide any course
It will give you the necessary start for Power BI.
You can further enhance your skills using
Mastering Power BI: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Expertise Power BI: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
Refer: medium.com/@amitchandak/structure-your-power-bi-learning-on-my-youtube-channel-1f745aa6c84e
I plan to start one, will announce on web.telegram.org/k/#@amitchandakda
Do you gv online classes?
I need to take classes for power BI
Hello sir
Sir course to acha hai but kya ye course ap hindi Mai bana sakte ho kya?? 😢😢😢
Hindi ka ek bada Video pending hain
Per series hai
सीखे Power BI हिंदी में 50+ videos : th-cam.com/play/PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki.html
Hindi on Demand 7 Videos - th-cam.com/play/PLPaNVDMhUXGYJM9Pgwa3tTgpu0EFb-TAG.html
Live Hindi (video 5,6) - th-cam.com/video/6mj7xoT7OTo/w-d-xo.html
Thank you so much sir 🙏🙏🙏