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
This shouldn't be a problem, have you looked through the 35 Time Intelligence Functions in DAX?
😎
- CLOSINGBALANCEMONTH Function (DAX)
- CLOSINGBALANCEQUARTER Function (DAX)
- CLOSINGBALANCEYEAR Function (DAX)
- DATEADD Function (DAX)
- DATESBETWEEN Function (DAX)
- DATESINPERIOD Function (DAX)
- DATESMTD Function (DAX)
- DATESQTD Function (DAX)
- DATESYTD Function (DAX)
- ENDOFMONTH Function (DAX)
- ENDOFQUARTER Function (DAX)
- ENDOFYEAR Function (DAX)
- FIRSTDATE Function (DAX)
- FIRSTNONBLANK Function (DAX)
- LASTDATE Function (DAX)
- LASTNONBLANK Function (DAX)
- NEXTDAY Function (DAX)
- NEXTMONTH Function (DAX)
- NEXTQUARTER Function (DAX)
- NEXTYEAR Function (DAX)
- OPENINGBALANCEMONTH Function (DAX)
- OPENINGBALANCEQUARTER Function (DAX)
- OPENINGBALANCEYEAR Function (DAX)
- PARALLELPERIOD Function (DAX)
- PREVIOUSDAY Function (DAX)
- PREVIOUSMONTH Function (DAX)
- PREVIOUSQUARTER Function (DAX)
- PREVIOUSYEAR Function (DAX)
- SAMEPERIODLASTYEAR Function (DAX)
- STARTOFMONTH Function (DAX)
- STARTOFQUARTER Function (DAX)
- STARTOFYEAR Function (DAX)
- TOTALMTD Function (DAX)
- TOTALQTD Function (DAX)
- TOTALYTD Function (DAX)