topic Quarterly Target to reset every quarter in DAX Commands and Tips

Quarterly Target to reset every quarter

yve214 — Wed, 13 Apr 2022 23:20:24 GMT

I currently have my quarterly targer set at 6. For me to get a daily target value in the case I selected a particular date, it gives me what I want. However I need the target value to reset every quarter. Below is what I have as my solution

Assuming I have a fixed expected quarterly target of 6.

This is how I want the table broken down if there is a date selection with their respective quarters.

Quarter	Date	Target
Q1 2022	1/7/2022	0.47
Q1 2022	3/25/2022	5.67
Q1 2022	3/31/2022	6.00
Q2 2022	4/8/2022	0.67

However, When I have it selected as a quarter, I get the numbers compounded like this. I get 6.07 when I select just Q2 2022 since it is taking 1st day of Q2 2022 which is 4/1/2022.

Quarter	Target
Q1 2022	6.00
Q2 2022	6.07

Expected Result: I want the target valies to reset every quarter so that it compounds to 6 by the end of every quarter.

Quarter	Target
Q1 2022	6.00
Q2 2022	0.07

Thank you for your help.

Re: Quarterly Target to reset every quarter

tamerj1 — Thu, 14 Apr 2022 02:59:20 GMT

Hi yve214
You can try

Target = VAR LastDateInFilter = MAX ( 'Date'[Date] ) VAR FirstDayInQuarter = STARTOFQUARTER ('Date'[Date] ) VAR LastDayInQuarter = ENDOFQUARTER ('Date'[Date] ) VAR DailyTarget = DIVIDE ( 6, DATEDIFF ( FirstDayInQuarter, LastDayInQuarter, DAY ) ) VAR Result = DailyTarget * DATEDIFF ( FirstDayInQuarter, LastDateInFilter, DAY ) RETURN Result

Re: Quarterly Target to reset every quarter

yve214 — Tue, 19 Apr 2022 15:45:58 GMT

tamerj1 , Thank you so much, this helped alot!