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...
Hello aforapple_27 ,
Could you please sharing some sample data and expected outputs, so that it could be easy for understand and give you best possible solution to resolve your issue.
Thank you.
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.