Forum Discussion
Solved
Count Date
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 |
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.
4 Replies
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.
