Forum Discussion

yaabandoh's avatar
yaabandoh
Frequent Visitor
5 years ago
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...
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
yaabandoh
Frequent Visitor
5 years ago
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's avatar
    Anonymous
    Not applicable
    5 years ago

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

    And use the month column from the date table.