Forum Discussion
Count rows based on Two dates
Hi Team, I have a data of Start date and End date and product id. I want to calcuate count of product Id based condition on start date and end date. Example- I want to calcuated count select...
Take a look at the function CALCULATE() it allows you to add more than one filter expression
VAR row_count = CALCULATE(COUNTROWS(table),startdate >= '1-8-2019' ,end date <= '31-8-2019')
this example assumes that there are not external filters on your table, if there are you might want to include a filter expression using ALL()---> ALL(table)
Hi,
Thanks for solution.
But I have to do it for all months. I am having data more than 3 years so i want to visuals year wise start date and end date values in X axis.
Please suggest.