Excellent. Thanks Wyn. 🙂

thanks, I was looking for something similar.

Wonderful. Thank you for this video.

Hi, thanks for the video. Highly Useful. Please let me know how to list all the guest details in a matrix. Please

oh, great even better than your initial video on this problem. It is always good to know both approaches, hence both approaches are good. Thank you

Fantastic video concise and to the point. I tried so many different ways to combine my Excel Workbooks with different sheet names, they all failed. I came across your explanation and voila, it works great. So useful. Keep up the good work. Thank you!

Amazing, thanks.

Full disclosure that I asked ChatGPT to write the following. My idea is, create a custom function that calculates and outputs the number of existing records for each step thus far. // Custom function to count rows for all steps (querySteps as list) as table => let // Generate a list of records where each record contains the step name and row count RowCounts = List.Transform(querySteps, each [StepName = _[StepName], RowCount = Table.RowCount(_[Table])]), // Convert the list of records to a table ResultTable = Table.FromRecords(RowCounts) in ResultTable let // Original data source Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], // Define each step FilterAB = Table.SelectRows(Source, each ([BloodType] = "AB-")), FilterLess170 = Table.SelectRows(FilterAB, each [Centimeters] < 170), FilterWA = Table.SelectRows(FilterLess170, each [State] = "WA"), // Create a list of steps with their respective names MyQuerySteps = { [StepName = "Source", Table = Source], [StepName = "FilterAB", Table = FilterAB], [StepName = "FilterLess170", Table = FilterLess170], [StepName = "FilterWA", Table = FilterWA] }, // Call the custom function to get the row count for each step RowCountsTable = RowCountFunction(MyQuerySteps) in RowCountsTable

Great video. Thank you 🎉

What a time savior! Thank you.

Very Useful, I've been battling this for many years

Hi, i tried to do this on my data but when I click the date columns it redirects me to a table, while clicking the time columns do the thing that your date columns do. what could be the problem on this it seems like my columns work the other way around

Sir, What do you mean by press control space bar, I tried but it's not working for me.

Does it include the hyperlinks?

Can we apply this in replacement based on condition????

Thank you for sharing! These tips are great, sharp, easy to remember in daily usage. Every beginner should watch this to save time on clicking and build their foundation.

Thank you!

Awesome. SUGGESTION for a new video: I'd love to see video on security in Power BI like permission settings, dataset sharing... step by step from the start to finish. Simple to understand as you always do Wyn. You already hinted in this video, but I'd still like to see your approach. TNX!

can you please explain List.Accumulate method from the start in order to combine Multiple excel file stored on Share point subfolder? As I could not find where to paste path of subfolder after following steps "Get Data>SharePoint Folder>enter root URL>Transform data"

Very cool, thanks Wyn

Worth mentioning how to loop through data model as there's a limit how much stuff you can call on one go.

Hi! Thank you for taking time to reply. I got that sorted. 💯

A year later I needed a quick solution to rename column headers and I have to admit Table.ToRows just blew my mind..it worked a charm. Thanks to Matt and you Wynn for sharing.

Absolutely brilliant! Solved the problem I was trying to solve for months.

Great one. but in my excel version (Microsoft® Excel® for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20114) 64-bit ), when i used this with a has =XLOOKUP(I6,tblProducts[Supplier],tblProducts[Product]), it returns an error. Why???

thanks but what if, i am not the owner and that file is shared with me ??

Thank you so so much! I can’t believe how brilliantly this worked, I’ve been trying to sort this for a while with no luck - and what a lovely bonus tip to include too! Thank you!

That's cool didn't know about that trick. That way of referencing Unique formula values works nicely for multi-level drop-downs as well.

The solution is super elegant. Thank you so much !!!

@accessanalytics There is a formatting option, not for the new calculation, but for the visual itself. Just add your new calculation. Then select your visual and select Format Visual | Gereral | Data Format | Apply Settings To and and then select you calculation name and there is a formatting option there

Beautiful

can we save the utcnow() output, to any text file, as i need to get the refresh date and time whenever the powerbi gets refreshed

Sadly this doesn't work if you want to show the values together, as can be seen in 4:38. It basically copies your first selected value to all the other enabled columns

Thank you for share I used to calculate these as a measure with Calculate(CountRows) before hitting "Close & Apply" (it was a hack while in temp memory). I don't remember exactly, it's been more than 3yrs. Do you know of any dedicated forum you recommend for such questions and answers?

Absolutely legend! Humanity rely on you. Lot of top you tubers got wrong here. You saving us. Bless you my friend. 🙏

Absolutely legend! Lot of top you tubers got wrong here. You saving us. Bless you my friend. 🙏

A clever trick to use "1" and eliminate the annoying sheet reference.

Could you not achieve the same with group by and count records

It's the reason why pq sits there evaluating

Not useful

बहुत बढ़िया जानकारी । ❤

Insightful, but I don’t have 365

Thank you sir. You are a saint

Awesome Trick very usefull . Thank you

The link to Chris Webb's Blog Post is the same as to your pbix-file. Could you please change this link to the blog post? :)

You saved my day! Million thks!

I also use office 365 but searchable drops down does not work even though it is fully updated. Can you please help?

This video save my time and money. Many Thanks!

Here is another excellent Wyn List presentation.

Hi and thanks for a great tutorial! What is the correct way to add more number intervals and thus colors to this measure?