Видео

Great job.... If I may ask for help? Is this possible? Could the dependant list be dynamic and it applies it to the drop down list? Example... Cell A1 is my dropdown list location. If B2=1.Then.... The drop down list (A1) will show. A, B, C to choose. BUT.... If B2=2 Then A1 drop down list will automatically change the choices to D, E, F. Continued.... But If B2=3 Then my drop down list in A1 will now show choices G, H, I, J, K.

also how are you importing so quickly. i am on vm and it is not working like that.

hi i am trying this with 8 mil rows via two csv files, but getting memory allocation error. I do have 64 bit excel.....

Good stuff.

yes thank you .. this helped me alot 😎

Awesome

Brilliant ❤👍. Thanks Wyn

Thank you! That was exactly what I was looking for! Finally I managed to connect with my subfolder on the Sharepoint.

I have this measure that returns text such as 50/12% BAC+ = IF([# BAC+]>0, FORMAT([# BAC+],"0") & "/" & FORMAT([% BAC+],"0%"),"") I want to conditionally format this measure using the following measure Met Bac+ target = IF( [bac+ target]<1, "", IF( [% BAC+] < [bac+ target] * [lower bound], "#FF4136", -- Target Not Met IF( [% BAC+] < [bac+ target]*[middle bound], "#FF8F00", -- Close to Target "#2E7D32" -- Target Met ) ) ) however, Power BI does format the text values, what am I doing wrong in this case? Thank you for all your education

GroupedTable = Table.Group( #”Trimmed Text” , { "Name", "Session" }, {{"Days", each Text.Combine( List.Sort ( List.Distinct( [Day] ), 0 ), ","), type text}} )

Thanks for sharing... here is my solution. After the TRIM step, with this code in one step we can get to the solution: = Table.Group( #{"Trimmed text", {"Name", "Session"}, {{"Days", each Text.Combine([Day], ","), type text}} ) I think it is the same solution, but without filtering the single day records.

Great job! Incredibly powerful!

If the start time of a person is the same as the start time of each shift, you might get the wrong results. That happens when the person's name is on top the null value which the second table creates (no names in that one). You shouldn't do just one sort. Immediately after the first one, add another sort. In this case sort the names. Since null is sorted on top, you now can fill down without any errors. I used to solve this with a combine but I like your method.

Thank you very much !! it is very helpful

Very informative! Love the clear explanation. 🙏🏿

Great explanation. What is the minimal price to get AI in Power BI? Should I buy Fabric (like F2) to get it?

I have always told people don't under estimate Excel...you see people rushing to learn python but they sweat when given a pivot tables in Excel 😂

Wow, great video! Thank You. I have a case where I want to connect to a hidden tab in an excel file stored in network, is it possible to do that? When I click combine on my file, it does not show up the hidden tabs.

How about if my excel doesn’t have sharepoint folder in my excel function.

How about moving a folder instead of file to sharepoint and reconnect power query?

I have completed the setup. However when I publish a file with increamental refresh and then I goto schedule refresh it show error in refresh. Error is "column Debit is not available" although column is available in dataset and there is no error in BI Desktop . However when I turn off increamental refresh then publishit again, then there is no such error. Any Idea how I can solve this?

Thanks Wyn. I'm sure this will be very helpful for lots of people (like myself) who are coming to the end of their Fabric trials.

Hi Wyn, I am a long-term learner from your/Access Analytics fantastic content, using my wife’s YT account today. I am PL-300 certified and studying for DP-600. Great to see you starting your journey with Microsoft Fabric! One point of note is data egress fees when working cross region in Fabric.

There is a way to automate this completely! If you write an object-based event operation macro for that worksheet, you can run a macro that would do the filtering for you if the value in your drop-down menu changed. And, in fact, you wouldn't even need your helper columns because all of those calculations could occur in the macro. In addition, you could build into the macro the automatic resizing of the table to eliminate the need for all of the blank rows in the first place. This way of doing things, there are 0 extra rows and 0 helper columns, leading to much smaller file sizes and a 100% automated table update when selecting from the drop-down. Same concept, better result. Does require VBA though.

Great video!

Amzing video! Thank you

Whenever I get to the bit of copying =XLOOKUP(AH4,Level1Choice,Level2Result)# I keep getting the "this entry leads to an error, try entering different values to continue" message. Happens on every single way I have tried to data validate. I have been at this for 4 days. I'm starting to think I will never get this to work :(

I must be dense, I didn't last 4 minutes before I was lost...you opened up a report with a pre-built calendar, where did you get the pre-built calendar from? Without that I couldn't continue on. Guess it's just me.

Sounds pretty useless for me

Thanks! It's straightforward to understand and follow.

awesome!

Hi this is a really good video! It's concise and straightforward for a novice like me. I was just wondering if there are any additional files that we were supposed to use from the sharepoint , because I only could see sales data related excel files. I had only sales by month in my data model so I couldn't really do anything from 8:27 in the video.

Amazing Job🔝

Thank you Wyn! As Fabric became a thing, I began wondering if I should diversify my learnings beyond Power BI. (No, at this time, but I'm happy to understand it better.) An idea for future videos: Maximizing Power BI for Pro Users and Consumers. Premium is not yet on the radar/budget for our organization. How can we make the most of building PBI reports and encourage consumption under Pro Licensing?

Best channel on RUclips

Excellent content for the organization. Thank you Wyn.

Thanks for the explanation 👍🏼, my company is moving all to Fabric, I work as a PBI developer in the insights and data quality team. In your opinion what will be the next tool to focus on learning and using ? Regards

I think this was a solid basic explanation that helps those familiar with Power BI and some of its admin features understand how Fabric expands upon the UI/UX. Thank you! If you were to dive deeper, I wouldn’t mind hearing you simplify the benefits of one lake - especially how it aims to unify data while minimizing the load of copies.

I take it those instructions only work in you can sign in to PBi? . I was just interested in having a look.

Amazing and simple explanation of fabric… I have spent over 5 months to try to understand the basics of fabrics .. thank you Wyn…❤❤

Wow.., very useful, let me know, Wyn What office is it ? Thanks anyway

Excellent video! Is it possible to apply to Sharepoint lists?

Um, how do you calculate Step 1: Number of Guests Checked In.....the lesson starts on Step 2: How to Calculate Events in Progress.

Awesome, Thanks a lot❤

Will this method work for csv files ?

A great video. It helped me a lot, thanks. I noticed that DAX has functionality for quickly building a calendar, but if you go that route, you can't use it in power query code, so I'd rather go for this version. A silly little thing: I noticed that you set up those first steps with 'parameters' for setting up key values. I've only done that using actual parameers, but this seems much simpler! How do you create those query steps?

Awesome. Fellow Midlander? Can hear a hint i think.

DSV thanks you for your service, at least NL

That Buffered and Ordinal function is going to be a life saver going forward!

I really can't thank you enough. I've been trying to work on it for the last two days with no luck.