Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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 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
@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!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |