Sales Projections with Variables based on YTD

[SINX]

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 of this group for this one because my plate is full and I need this win!

I would like a card to show: (I am assuming I need a new column to calculate the values?)

- "Projected Sales" Card - based on "Gross Sales" Column - Divide the total sales $ shown by the number of unique instances in the date selection, multiply by 12. - Every closing is set to the last day of the month, so no matter how many customers, the last day of the month is common - this means there are only as many unique dates as the number of months that have closed YTD. 

IF there is a way to do this for the previous 12 unique instances, I might be able to use that as well. 

As an added bonus - I need the following if possible to change the sales projection based on upcoming changes such as capacity and time. 

- Multiple input fields that would change the outcome of the "Projected Sales" Card result.

Is this possible? Or at least the card itself?

Thank you!!

[v-jingzhang]

Hi @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.