Forum Discussion
Group by with filters power query
Hi, I want to create in Power query the next table 1) I need to group by the ones that have the same date and hour 2) in each group make an "IF" selecting just the ones that have "Y...
Hi See attached the power bi file
you need to do multiple group by's to get the desired result.
vanessafvg
Community Champion
Community Championplease provide your data in text format.
Sure vanessafvg
Original table
Es Date Cost Correct x y z
05/10/2021 07:05:43 p. m. 10 No Example Example Example
05/10/2021 07:13:06 p. m. 5 No Example Example Example
05/10/2021 07:13:06 p. m. 4 No Example Example Example
06/10/2021 05:17:13 p. m. 6 Yes Example Example Example
06/10/2021 05:17:13 p. m. 5 Yes Example Example Example
06/10/2021 05:17:13 p. m. 2 Yes Example Example Example
06/10/2021 05:17:13 p. m. 1 No Example Example Example
Result table
Es Date Cost Correct x y z
05/10/2021 07:05:43 p. m. 10 No Example Example Example
05/10/2021 07:13:06 p. m. 4 No Example Example Example
06/10/2021 05:17:13 p. m. 2 Yes Example Example Example
- vanessafvg
Hi See attached the power bi file
you need to do multiple group by's to get the desired result.