Forum Discussion
Post ProdigyGrouping by Distinct Date and Interval
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.
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.
Post ProdigyAnonymous 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.