July 21, 2017 at 10:50 am
I have created a simple Model, 1 Fact table, 1 Date table and 1 Dimension Table.
The data relates to captured metric of Actual against Targets. Metric is 1 year long and broken down by Quarter.
I can match Actual Against Target, but what I'm failing with is tracking Quarter on Quarter growth, where at the beginning of the new year it resets. I can get QoQ or YoY through all years.
Is what I'm looking for possible? If so can someone help
July 23, 2017 at 1:31 am
darrenkelly - Friday, July 21, 2017 10:50 AMI have created a simple Model, 1 Fact table, 1 Date table and 1 Dimension Table.
The data relates to captured metric of Actual against Targets. Metric is 1 year long and broken down by Quarter.
I can match Actual Against Target, but what I'm failing with is tracking Quarter on Quarter growth, where at the beginning of the new year it resets. I can get QoQ or YoY through all years.Is what I'm looking for possible? If so can someone help
This shouldn't be a problem, have you looked through the 35 Time Intelligence Functions in DAX?
😎
July 23, 2017 at 8:50 pm
Also take a look at this
http://www.daxpatterns.com
It may even have the calc you are after.
July 23, 2017 at 10:08 pm
There's even an example XLS file...
http://www.daxpatterns.com/budget-patterns/
If you want Q1 to ignore the previous quarter (Q4 of previous year), you could do something simple like
IF(Calendar[Quarter]="Q1",BLANK(), SUM([BudgetQty]))
August 3, 2017 at 3:11 am
Apologies for the delay in responding - just completed two upgrades, SharePoint 2007 to SharePoint Online and SQL 2008 to SQL 2016, now that the dust has settled, I have some spare capacity again 🙂
Thanking you all for providing me with the information and links.
Much appreciated.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply