Count rows based on Two dates

[Anonymous]

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 count (*) from tabel

where startdate >= '1-8-2019' and end date <= '31-8-2019'

 So want to calculate count for every month Jan to Dec based on Start date and end date.

Could you please give some idea about this.

Thanks

[kentyler]

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)

[Anonymous]

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.

[Anonymous]

Got solution from blow link

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=2532cdc3-...

Thanks!