Forum Discussion

zervino's avatar
zervino
Helper I
1 year ago

Multiple measures to compare different years

I have data with the following structure:

 

YearMonthSales
2023 Actuals1100
2024 Actuals1120
2025 Actuals1110
2025 FC1130
2025 Budget1125

 

It contains data for all months and the year is a year/plan combination.

 

I want to have multiple measures of this type: 2025 Actuals vs 2024 Actuals, 2025 Actuals vs 2025 FC, etc.. and also same comparisons but iņ percentage. Eventually if I create one measure per combination I will end up with many measures. Is there a best practice to deal with this situation? A better way to get these comparisons?

Need Help
Show and Tell

7 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Your data is already in the right format. Let the user choose what they want to compare against each other, and use Visual Calculations to do the actual compare.

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Hi zervino 

    If you really want to have less measures then use visual calculations

    If you  want more flexibility, use regular DAX.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi zervino ,

    Did the replies offered help you solve the problem, if it helps, you can consider to accept it as a solution so that more user can refer to, or if you have other problems, you can offer some information so that can provide more suggestion for you.

    Best regards,

    Lucy Chen

  • v-dineshya's avatar
    v-dineshya
    Community Support
    1 year ago

    Hi zervino ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    If danextian response has resolved your query, please mark it as the Accepted Solution to assist others. 


    Thank you

    • v-dineshya's avatar
      v-dineshya
      Community Support
      1 year ago

      Hi zervino ,

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
      If our response addressed, please mark it as Accept as solution and consider giving a KUDOS. Feel free to reach out if you need further assistance.

       

      Regards,

      Dinesh

      • v-dineshya's avatar
        v-dineshya
        Community Support
        1 year ago

        Hi zervino ,

        As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
        If our response addressed, please mark it as Accept as solution and consider giving a KUDOS. Feel free to reach out if you need further assistance.

         

        Regards,

        Dinesh