Grouping by Distinct Date and Interval

[jcastr02]

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

[Anonymous]

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.

[jcastr02]

@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?

[Anonymous · Accepted solution]

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.