Forum Discussion

ttcalendar's avatar
ttcalendar
Frequent Visitor
2 years ago

Compare Forecast Version

Hello,   Every month we release a new revised forecast for our sales person to populate forward forecast numbers. I have another table which actual sales come through. When sales actualise, I need ...
Need Help
ttcalendar's avatar
ttcalendar
Frequent Visitor
2 years ago

Hi Anonymous,

 

Thanks for the help! Much appreciated.

 

Instead of hard coding the forecast version in the calculate measures, I would like to present the user the option to select from 2 slicers to select the forecast versions they want to compare. 

 

How can I incorporate this?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ttcalendar ,

     

    I am confused about what your table looks like. Is Actual data and Forecast data in different tables like my sample or in the same table?

    Your calculation is based on your data model. Please share a sample file with me.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • ttcalendar's avatar
      ttcalendar
      Frequent Visitor
      2 years ago

      Hi Anonymous 

      Apologies, the actuals and forecasta data are in different tables like yours. Attached is a sample.  

       

      Sample PBI