Help needed with sales formula

Question

I'm looking to create a projected sales formula for the remainder of the fiscal year. I have 2 measures: YTD sales and YTD sell days. The formula divides the YTD Sales by the YTD sell days and then multiplies by the total 254 sell days in the fiscal year. Formula is as follows FY22 Projected Sales = [FYTD 22 Sales (Ex Flu)]/[FYTD22 Sell Days]*254

I can't seem to get any results to populate from this expression and was hoping for some assistance with this. Appreciate any help.

parry2k · Answer

dmoney7612&nbsp;you need to provide sample data and the measure you are using for the calculation and also how you are visualizing the data.&nbsp;Read this post to get your answer quickly. https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

dmoney7612 · Answer

The data is sensitive so not sure how I could provide a sample of the measures and such. Any suggestions?

parry2k · Answer

dmoney7612&nbsp;create sample data and reproduce the measures.

anonymous · Answer

I typically change the data and provide similiar, but fake data. For example, I have specific customers where I work and instead of using them I just use fake ones like Apple, Microsoft, etc.&nbsp;

v-easonf-msft · Answer

Hi,&nbsp;Anonymous&nbsp;
There may be a lack of context.
Try to use&nbsp;complete formulas to replace measures [FYTD 22 Sales (Ex Flu)] and [FYTD22 Sell Days] .
&nbsp;
Best Regards,Community Support Team _ Eason

Forum Discussion

Help needed with sales formula

5 Replies

Related content

Need help with DAX Formula

Need formula help

If formula

need to display monthly sales and 6 month average sales for products

formula