Tracing activity over time

[kasiaw29]

Apologies if this question was asked before. 

I'm tasked with creating a visual which shows % of sales activity by sales people by quarter & month but measure is to calculate quarter 1 rolling for example and stop and start new rolling calculation in quarter 2 and so on. 

In example below I was able to work out monthly % of activity based on how many sales people sold vs. how many sales people there are. This is working great but it's not yet what I need, what I need is what I was able to work out individually in white boxes

As you can see I'm getting values in first month of a quarter, then combined 1 &2 and finally 1 &2&3. 

What is the best way to get this representation on bar chart? 

[amitchandak · Accepted solution]

@kasiaw29 Are you looking how get the formula, Then the answer is datesqtd with a date table

ExampleQTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))

Are you looking for a visual suggestion?

Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0

[kasiaw29]

@amitchandak was hoping for dax guidance that you have provided. I was using DATESYTD in one of the attempts...now I know why it didn't work 😖

Time to log off for the weekend.

Much appreciated!