Sales Forecast with no sales on some days

[Mariollo]

I would like to create a sales forecast visualization.

I can do this for monthly values with no issues, the problem is when it comes to daily values.

I have no sales during weekends, holidays etc.

I do not have those dates in my export excel from DWH.

I tried some workarounds like connecting dates with numbers etc but it doesn't do the work.

Any ideas from you?

[v-yangliu-msft · Accepted solution]

Hi  @Mariollo ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Sum =
var _sum=
IF(WEEKDAY(MAX('Table'[date]),2)<=5,SUM('Table'[amount]),0)
return
IF(_sum=BLANK(),0,_sum)

2. Result:

Dates with data will be displayed, dates without data are displayed as 0

Best Regards,

Liu Yang

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

[amitchandak]

@Mariollo , Join withs sales table and create a measure with +0

sum(Sales[sales])+ 0

or use this option and then export