Forum Discussion
Grouping by Distinct Date and Interval
I am trying to group and get a count of how many intervals a store had. Example, below there were 6 unique dates with the interval 22:00. I'm having some difficulty with grouping? or perhaps there is an easier solution?
11/6/2023: 22:00
11/7/2023: 22:00
11/9/2023: 22:00
11/10/2023: 22:00
11/13/2023: 22:00
11/14/2023: 22:00
Hi, jcastr02
Thanks for your reply, I think it's feasible to implement your request in Power Query.
1. In the Power Query interface, select the Merged column, right-click, and select Remove Duplicates.
2. Select the Interval column and click Group By.
3. This will give you the result you want.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi, jcastr02
Based on the information you have provided, Here are my answers to your questions.
You can optionally complete the merging of these two columns in Power Query and concatenate them with ":".
This way you can see the style you need on Visualization.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Thank you - I had tried this as well, but I'm trying to get a count somehow within Power Query that would then show that the 22:00 interval total unique count is 6. Is there a way to achieve this?
Hi, jcastr02
Thanks for your reply, I think it's feasible to implement your request in Power Query.
1. In the Power Query interface, select the Merged column, right-click, and select Remove Duplicates.
2. Select the Interval column and click Group By.
3. This will give you the result you want.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
