Quarterly Target to reset every quarter

[yve214]

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.

[yve214]

@tamerj1 , Thank you so much, this helped alot!

[tamerj1 · Accepted solution]

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