Forum Discussion
Active opportunities
Anonymous , Refer my blog on similar topic
Anonymous , No worries you can accept two solutions. Please find the attached file. As I do not see any null end date , omitted that clause
amitchandak do you know a way how I can show week 1-52 on the x-axis instead of months? Probably need to addapt my date table?
Yes - Check the calendar in links
Sun to Sat week -https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0
Mon-Sun Week https://www.dropbox.com/s/a9xq913pgvuzg2x/sales_analytics_weekWiseMon_sun.pbix?dl=0
Hi amitchandak I have an additional question for this. Don't know if I should make a new topic for this cause then I have to explain everything again. But right now thanks to you I have the active opportunities summed up per month. this looks like this:
Here is a link to Sample data: