Forum Discussion

aforapple_27's avatar
aforapple_27
Frequent Visitor
1 year ago

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...
Tutorial Requests
aforapple_27's avatar
aforapple_27
Frequent Visitor
1 year ago

hi Anonymous , hnguy71 

I tried both of your code but unfortunately it didn't work as expected. My table is doing comparision between sales data of 2025 and 2024 on month by month basis. The thing is both with my code and your code, it shows up blank whereever selected year in slicer has no transaction. For example, if there was no transaction in March, 2025, It comes up blank for that month transaction ( which is expected) but it also comes up blank for 2024, ( there is transaction in March 2024).

 

Please let me know if you guys need any more information to support me through this.

hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
1 year ago

Hi aforapple_27 

Do you mind sharing some sample data and expected outputs?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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.