Count Date

[yaabandoh]

Please I need help: I want to show that number of products that were relaunched in a particular month. I want to display this on a bar chart with my x-axis as the month-year, with the bar showing the number of products relaunched. There are some products that were not relaunched, and some months where no product was relaunched. Below is a sample Table:

Product Code	Date	Date Relaunched
A1	7/1/2020
B1	7/1/2020	10/15/2019
C1	7/1/2020	9/24/2019
A2	7/1/2020	10/4/2019
B2	7/1/2020	10/3/2019
C2	7/1/2020	5/29/2020
A3	7/1/2020	9/26/2019
B3	7/1/2020
C3	7/1/2020	5/29/2020
A4	7/1/2020	9/24/2019
B4	7/1/2020	6/18/2020
C4	7/1/2020	6/18/2020
A1	8/1/2020
B1	8/1/2020
C1	8/1/2020
A2	8/1/2020
B2	8/1/2020
C2	8/1/2020
A3	8/1/2020
B3	8/1/2020
C3	8/1/2020
A4	8/1/2020
B4	8/1/2020
C4	8/1/2020

[Anonymous]

@yaabandoh  

Hey mate ,

You can use this .

Test = COUNTROWS(VALUES(Sheet1[Date]))

Cheers 

[Anonymous · Accepted solution]

@yaabandoh  Yu can create a measure like below-

Products Relaunched = CALCULATE(COUNT('Table'[Product Code]),FILTER('Table','Table'[Date Relaunched]<>BLANK()))

And your visualization would look like this- 

Appreciate your kudos!! Please accept this post as solution if it helps.

[yaabandoh]

@Anonymous Thank you. Please I will like the graph to show bars for all the months, with 0 values for where there is no relaunch.

[Anonymous]

@yaabandoh Create a date table and make a relationship with the data table.

And use the month column from the date table.