Just wanted to give you a big THANK YOU! The summarize text section is exactly what I have been looking for and your explination and example was tremendously helpful.
Because it creates a Table in each row. We can then use all the M code Table.xxxxx functions in a Custom Column to manipulate those Tables. It's mind blowing.
Another excellent video Mark. I was previously aware of the Text.Combine trick but was plagued by the duplicate values in the cell. You made my day today with the List.Distinct() addition. Since the need for summarizing text is quite common, do you think Microsoft will add that as an option instead of forcing us to use the Sum workaround as you present?
You're welcome Jim. It would make sense to add Text.Combine to that list (along with as many other possible options), but I think it's unlikely for quite a while. I know the Power Query team are working on some pretty big stuff at the moment, so I doubt that will revert any resources for something like this at the moment.
Excellent. I have a question: is possible Create groups for specific dates ? Example: my field date is day by day but I need group by month (Sum values) and March I need day by day 😅 thanks
@@ExcelOffTheGrid thank you 😊 for fast response, highly appreciated but I know this feature, and as I understood from ur reply that's my need not coverd on group by tool. Am right ?
So you want to Group By and then remove duplicates inside each Group? To do that - use Group By with the operation on All Rows. Then add a custom column with the Table.Distinct function applied to each row. Finally, expand the Tables.
@@ExcelOffTheGrid actually, I tried but it's doesn't work good as when I expand the custom table all Duplicated are reflected again despite of I used table.distinct function!!
![Excel to Power BI [Full Course] 📊](http://i.ytimg.com/vi/gjnnqsdvAc0/mqdefault.jpg)
![Excel to Power BI [Full Course] 📊](/img/tr.png)
Just wanted to give you a big THANK YOU! The summarize text section is exactly what I have been looking for and your explination and example was tremendously helpful.
Great video Mark.
Excellent job! Thank you 😊
You’re welcome.
The last case of "All rows" is very interesting. Excellent and brilliant explanation Mark. Thanks!!
Because it creates a Table in each row. We can then use all the M code Table.xxxxx functions in a Custom Column to manipulate those Tables. It's mind blowing.
Your content is excellent. You are very didactic. Thank you!!
Thank you, I appreciate that! 😁
This was super helpful for a project I recently did. Thanks for sharing, really appreciate it.
Well done! Excellent presentation, as I learned something new. Thanks!
Glad you enjoyed it!
Thanks. I find this really useful.
Clear, perfect Thanks
You're welcome!
Thank you for sharing
My pleasure
Thank you!
You're welcome!
Great video Sir!,
Just to confirm: is this "Group By" feature, the equivalent to use the SUMMARIZE() DAX expression?
how can I apply Group by where I have multıple colums? product X Y Y sum for each months seperately ?
Another excellent video Mark. I was previously aware of the Text.Combine trick but was plagued by the duplicate values in the cell. You made my day today with the List.Distinct() addition.
Since the need for summarizing text is quite common, do you think Microsoft will add that as an option instead of forcing us to use the Sum workaround as you present?
You're welcome Jim.
It would make sense to add Text.Combine to that list (along with as many other possible options), but I think it's unlikely for quite a while. I know the Power Query team are working on some pretty big stuff at the moment, so I doubt that will revert any resources for something like this at the moment.
Excellent. I have a question: is possible Create groups for specific dates ? Example: my field date is day by day but I need group by month (Sum values) and March I need day by day 😅 thanks
Add a month column, then perform the Group By.
You can always remove the column later if you don’t need it any more.
Hello sir...if my data have Duplicated on one column and I need to make a group by by this column to be unique data for my file
Select the column then click Home > Remove Rows > Remove Duplicates
@@ExcelOffTheGrid thank you 😊 for fast response, highly appreciated but I know this feature, and as I understood from ur reply that's my need not coverd on group by tool. Am right ?
So you want to Group By and then remove duplicates inside each Group?
To do that - use Group By with the operation on All Rows.
Then add a custom column with the Table.Distinct function applied to each row.
Finally, expand the Tables.
@@ExcelOffTheGrid thnx a lot 😊 I will try it ...
@@ExcelOffTheGrid actually, I tried but it's doesn't work good as when I expand the custom table all Duplicated are reflected again despite of I used table.distinct function!!
list distinct --- i needed this bad
I’m glad you found it useful.
Using the Text.combine, the resulting column still shows errors - how do you fix that?
Is the column a text data type?