Help needed with sales formula

[dmoney7612]

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]

@dmoney7612 create sample data and reproduce the measures.

[parry2k]

@dmoney7612 you need to provide sample data and the measure you are using for the calculation and also how you are visualizing the data. 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]

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

[Anonymous]

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. 

[v-easonf-msft]

Hi, @Anonymous 

There may be a lack of context.

Try to use complete formulas to replace measures [FYTD 22 Sales (Ex Flu)] and [FYTD22 Sell Days] .

Best Regards,
Community Support Team _ Eason