Відео

Thank you a lot

Thanks for your share, it`s supper good methods. Each method is a way to understand different functions. thanks!!

How about that when it comes to Expand solution? Too simple? = Table.ExpandTableColumn(#"Grouped Rows", "Details", List.Difference(Table.ColumnNames(#"Grouped Rows"[Details]{0}), Table.ColumnNames(#"Grouped Rows")))

Very useful tips, thanks a lot Rick

Could you please share the file so we could follow along?

Just received your book, Definitive guide to power query in the mail. Can't wait to get into it

Awesome! My favorite channel about M Code :)

The last video I watched to do this FROZE my power BI. YOU made this so simple. Do you have a video that will ONLY refresh new data? I tried to follow other videos with no luck. I want to only refresh the new data, without having to refresh all the data, and freezing my computer for 10 minutes [millions of lines of data].

Just amazing! Thanks

There is a lot of gold in that book.

🎉

In the last scenario, Dynamically Expand Columns, I add a new column to the inner table with the content of the column of the outer table I want to keep. So I can use Table.Combine instead of Expand.

Really intesting, will have to re watch a few times, did not realise when value () returned a table in also included the column type albeit hidden, I recently discovered Table.schema, which I will one day discover a use for, but it is pretty impressive.

Thanks a lot. Type.TableSchema was new to me, wow this is huge.. .

Wow! Je komt de laatste tijd wel met echt goede ideeën Rick! Deze video geeft weer veel inzicht in PQ Dankjewel

Hi Rick, If I buy the paper book version, will I get PDF version aswell?

🤯 thanks for sharing this!

Great work. It deserves an award or at least significantly more success on UA-cam traffic

Hey Excellent Very well Explained. But I faced a issue When I Select Filters and Click on above Button to Hide Panel so that I can see the Charts with Applied filter . whole dashboard is reset. is anybody facing this issue ?

Great video, Rick. When using list contains with if and the criteria are text, is there a way to make the if ignore the text case. e.g the criteria "ABC" also works for "abc". It would help reduce the number of criteria in the list....

Excellent clear video, thank you!

When I filter it is not showing me native query but it show in above step. I am getting my data from API from Zappysys through ODBC connection can it be possible to get increment refresh

I have yearly data i can do group by which will filter and calculate sum or any other valies i want but the thing is i want to insert that groupby for each month end .. can you do a video

I think there is an error in Chapter 3. On Page 59, in the section about Folders, 2nd paragraph, describes how Folder.Contents and File.Contents works. I think you meant to describe how Folder.Contents and Folder.Files work? Also, what is said about Folder.Contents is confusing. It implies that the function will delve into each folder within the path. But this function's scope is only the folder that's fed to it

Thank you for these excellent tips, BI Gorilla! I have a question: instead of typing the list of names in editor mode, is it possible to create a reference table in Excel and use this method to check if a column contains items from the reference table? This way, it will be much easier for a user to revise the list of names to look up.

Thank you, I was struggling with the table concept of this, but this video helped me understand it.

thank you

Thank you.

Purchased !!

Very helpful video, however I need to add something ( maybe it is because, two years ago native query was disabled in PQ in general ? ) You mentioned about "View native query" option that can not be greyed out, which is not 100% true. It can be greyed out and still incremental refresh works. For example for Databricks data source. Even though "View native query" is disabled, using -> Databricks.Query() function to create a SQL statement with RangeStart and RangeEnd parameters makes incremental refresh works. All the steps in terms of configuration after PQ, has not changed.

How would it be, add that the cut off day is dynamic, for example that the accounting closes on the 27th of each month or whatever day it is.

thankx for your share!

🙏🙏🙏

Please add the explanation of the sorting inside the group for the running total calculation; probably is related to the usage of GroupKind.Local. Thanks!

This was helpful, thanks!

awesome

Great video, very clearly explained and easy to follow. Thanks

This is a great tutorial to create total percentages in DAX. I have one question I'd would like your help. Let's say I am creating a matrix visual about some population distribution across states. I also break down the states' distribution by demographics such as age group, gender, race group (in the matrix, state is the row field, and gender, or age group, or race are the columns). To show the row percentages for different categories of age group, gender, or race group, I would like to create a DAX measure; the row total disregarding gender should be: VAR population_rowtotal= CALCULATE( [# population], REMOVEFILTERS(pop_final[gender] ) ) I can calculate the row percentages as DIVIDE([# population], [population_rowtotal]). This DAX measure is for row percentages for gender only. I can also create DAX measures for row percentages of race, or age group. But I would like to use a parameter including gender, race, age groups, as the column in the matrix. So the matrix will be dynamic based on the column field I select. That means the Dax measure of row total / percentage should also be dynamic based on the selected column field. How can I achieve this in the DAX measure statement: REMOVEFILTERS(pop_final[gender] or [racegroup] or [agegroup]). Thanks.

Curious how their performance compares. P.S. Found another way in a comment by Imke Feldmann in the ExcelGuru forum: Do FullOuter join, then: = Table.SelectRows(#"Expanded NewColumn1", each [Issued.Cheque] = null or [Issued.Bank] = null

I love you 😳

Ooh I like that, not seen this before.

At the end of the video,the method to deal with "null" is so great, it is a perfect solution.

Cool! But what if it is not about dates. I have categories and product slicers. When I select a category then in the product slicer nothing is selected by default and therefore the visuals are showing nothing or mistakes. I want a default selection of product when something is getting selected in category. How can we do that?

How did you get the visual graphics/bars showing what is valid,error etc?

Last one month i am searching for good website and UA-cam videos for M language. But i didnt get. Today i checked in linkedin . I found your website and i get confident to learn and it was very clear and very easy to understand. Thanks a lot.

Actually is not Lisa...

Great video - love the default / actions prompts on the button functions. Thanks 👏

I just ordered the book. I hope it has a link to sample files.

Is it possible create a list in excel then import in PQ and use that list to select which columns we want?

what happened if we need the share of the productos? I mean that the sum of % products to be 100% for example: Class deluxe: 16% A.Datum Super :57% A.Datum Constumer: 43%