How can I group unique column values into counts by date?

[pmh_001]

I have a table of transaction records that includes 2 columns: DateOfTransaction, and ItemNumber. Each time a transaction occurs, the date and item number are logged into the table. There are multiple transactions per day, sometimes with the same items being sold in seperate transactions. There are over 500 days in my table. I want to be able to group my data so my dates stay chronological, and a new column is created that displays the count of each ItemNumber that was sold for that day.

For example, this is what I have:

      Date         ItemNumber

05/20/2021	SGHH123
05/20/2021	APJ984
05/20/2021	SGHH123
05/21/2021	APJ984
05/21/2021	APJ984

And this is what I want:

 Date          ItemNumber    ItemNumberCount

05/20/2021	SGHH123	2
05/20/2021	APJ984	1
05/21/2021	APJ984	2

I'm very stumped on how to achieve this result. Thank you so much in advance!

[parry2k · Accepted solution]

@pmh_001 add a measure and drop this in the table visual:

Item Number Count = COUNTROWS ( YouTable )

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[pmh_001]

This worked! Thank you.

[Ashish_Mathur]

Hi,

Drag the two fields to a Table visual and write this measure

Measure 1 = countrows(data)

Hope this helps.