cancel
Showing results for
Did you mean:
Resolver II

## Tracing activity over time

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?

1 ACCEPTED SOLUTION
Super User

@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

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!
2 REPLIES 2
Super User

@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

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!
Resolver II

@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!

Announcements

#### The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

#### Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!