Forum Discussion
Sales Projections with Variables based on YTD
I have a report where I am trying to create a column to show the following calculation: I am new to this, but I am getting some nice stuff done! Anyway, I am hoping to tap into some of the knowledge ...
v-jingzhang
Community Support
Community SupportHi SINX
It should be possible but it would be better if you could provide some sample data and expected result, so that we can help write the measure you need.
As of now, you can create measures like below.
Projected Sales = DIVIDE([Total Sales], [Number of Unique Instances]) * 12
Total Sales = SUM('Table'[Gross Sales])
Number of Unique Instances = DISTINCTCOUNT('Table'[Month])
If you want to have "Multiple input fields that would change the outcome of the 'Projected Sales' Card result", you can use What-if paramters, or create custom tables with field values and use them in slicers in the report. Then use SELECTEDVALUE to get the selected value and use it to replace some part in the measures.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.