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.
@IvanCortinas_ES
Жыл бұрын
The last case of "All rows" is very interesting. Excellent and brilliant explanation Mark. Thanks!!
@ExcelOffTheGrid
Жыл бұрын
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.
@angelmaravilla4708
2 ай бұрын
Great video Sir!, Just to confirm: is this "Group By" feature, the equivalent to use the SUMMARIZE() DAX expression?
@marckirsch
2 ай бұрын
This was super helpful for a project I recently did. Thanks for sharing, really appreciate it.
@vwij1736
9 ай бұрын
Great video Mark.
@leftindependent
7 ай бұрын
Excellent job! Thank you 😊
@ExcelOffTheGrid
7 ай бұрын
You’re welcome.
@c.e.bingham2079
Жыл бұрын
Well done! Excellent presentation, as I learned something new. Thanks!
@ExcelOffTheGrid
Жыл бұрын
Glad you enjoyed it!
@Pradonis7
6 ай бұрын
Your content is excellent. You are very didactic. Thank you!!
@ExcelOffTheGrid
6 ай бұрын
Thank you, I appreciate that! 😁
@SandyChan-u7h
Жыл бұрын
Thanks. I find this really useful.
@Charly_MC
Жыл бұрын
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
Жыл бұрын
Add a month column, then perform the Group By. You can always remove the column later if you don’t need it any more.
@andrewsinha2785
Жыл бұрын
Clear, perfect Thanks
@ExcelOffTheGrid
Жыл бұрын
You're welcome!
@Picla_Peremohy
Жыл бұрын
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?
@ExcelOffTheGrid
Жыл бұрын
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.
@orkunakar9057
9 ай бұрын
how can I apply Group by where I have multıple colums? product X Y Y sum for each months seperately ?
@eslamfahmy87
Жыл бұрын
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
@ExcelOffTheGrid
Жыл бұрын
Select the column then click Home > Remove Rows > Remove Duplicates
@eslamfahmy87
Жыл бұрын
@@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 ?
@ExcelOffTheGrid
Жыл бұрын
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.
@eslamfahmy87
Жыл бұрын
@@ExcelOffTheGrid thnx a lot 😊 I will try it ...
@eslamfahmy87
Жыл бұрын
@@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!!
@SeemaSharma-lj3cf
Жыл бұрын
Thank you for sharing
@ExcelOffTheGrid
Жыл бұрын
My pleasure
@leiterservices
Жыл бұрын
Using the Text.combine, the resulting column still shows errors - how do you fix that?
Пікірлер: 34