Measure sales forecast

[mnb_dk]

Hi

I'm looking for help to solve this calculation.

I have two columns of sales: This Year & Last Year.

I want to calculate expected sales if I serve the same customers as last year.

Example:

Total sales this year is 240 based on two customers (A + B). We still need to serve the last customer (C). If customer C buys for same amount as Last Year (100) we will expect our total sales to be 120+120+100 = 340

Customer	This year	Last year
A	120	100
B	120	100
C		100
Total	240	300

How does the calculation look like?

Best regards

Mathias

[amitchandak]

@mnb_dk , a new meausre

Sumx(Values(Table[Customer]), if(isblank([This Year]), [Last Year], [This Year]))

[mnb_dk]

Hi Amit

Thanks for replying.

Unfortunately this didn't return the correct value.

It retuns the total value from Last Year.