Dynamic Target

[Beginner_2020]

Hi PowerBI Community, 

i have the target of 2,75 %. Now I need every quarterly/ 3 months to reduce the target by -0,25 %. 

So 2,75 - 2,5 - 2,25 - 2,00 %
     1. Q    2. Q  3. Q   4. Q

The dynamic target should stop after 2,00 %

How can I achieve this?

[v-chenwuz-msft · Accepted solution]

Hi @Beginner_2020 

Traget =
VAR _firstdate =
    MINX( ALL( Table ), [Date] )
VAR _currentdate =
    SELECTEDVALUE( Table[Date] )
VAR _diff =
    DATEDIFF( _firstdate, _currentdate, QUARTER )
VAR _target = 0.0275 - 0.0025 * _diff
RETURN
    IF( _target < 0.02, 0.02, _target )

You can try dax like the above.

Please share some example data and except result, if you need more help.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.