Active opportunities

[Anonymous]

I have another question, we do have these opportunities that have a start and end date. We would like to have a visual (barchart) X-axis = months jan to dec. Y axis = count of possible opportunity.

Opportunities       -->       startdate       -->       enddate
Opp1                                01/05/2020                31/12/2020
Opp2                                24/04/2020                31/12/2020 

Opp3                                01/03/2020                31/12/2020 

Opp4                                01/03/2020                31/12/2020   

Problem here is that it would only count the number of opportunities on the months: march(03) / april (04) / may (05). while these projects do are also active on the months june, july, aug, ... Dec

Link to sample pbix file

https://1drv.ms/u/s!AvlpOfUDGFD5tBA9z0mIrFpx61tx?e=npZLNq

Any ideas?

[amitchandak · Accepted solution]

@Anonymous , Refer my blog on similar topic

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970