Forum Discussion
How can I assign Single value to a variable dynamically?
Amount for Previous Year = var prevYear = Calculate(SELECTEDVALUE('Raw data'[Year])-1) var prevYearFinal = prevYear return CALCULATE(SUM('Raw data'[Amount]), 'Raw data'[Year] IN {2024}) Abov...
Hi aforapple_27 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Nope this issue is still not fixed. I would need to make a dummy data i guess so that you guys could work through it. Just haven't been able to wrap my time around it
Hello aforapple_27 ,
Thank you for the update. When you have a moment, please share a dummy dataset or a simplified version of the model. This will help me reproduce the issue more accurately and assist you better.
Thank you.