Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
Hi @Anonymous
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.
Hi @Anonymous
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.