cancel
Showing results for
Did you mean:
Helper V

## Dynamic Target

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?

1 ACCEPTED SOLUTION
Community Support

``````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.

Community Support

``````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.

Announcements

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

#### What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.