Nested if with multiple conditions

[Rubal]

Hi,

need some help with a DAX nested if statements with multiple conditions as per below

if Actual or Forecast = "Forecast"

then volume (cases) * growth factor and volume(SUOM) * growth factor

else if Actual or Forecast = "Actual" then volume (cases) , volume (SUOM) 

Thank you.

[Anonymous]

Hi @Rubal 

Better give an example with actual numbers.

It is hard to understand your requirements.

Thanks

A

[Rubal]

---

@Anonymous wrote:

Hi @Rubal 

Better give an example with actual numbers.

It is hard to understand your requirements.

Thanks

A

---

	Actual	Forecast
	Jan-18	Feb-18	Mar-18	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Sep-18	Oct-18	Nov-18	Dec-18	Jan-19	Feb-19	Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19
Volume Case	2	3	2	3	2	3	2	3	3	4	5	2	3	2	3	2	3	2	2.2	3.6	3.6	5.2	5.5	2.8
Volume SUOM	20	30	20	30	20	30	20	30	30	40	50	20	30	20	30	20	30	20	33	24	36	39	44	70
Growth Factor	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1.1	1.2	1.2	1.3	1.1	1.4

I would have a filter for Actual and Forecast. When I select actual it will only show data available till June 19 and Forecast will show July 19 - Dec 19.

Therefore, if the filter is "Actual" I get the Actual Volume and Actual Volume SUOM, However, if the filter is Forecast I will have the growth factor multiplied for the same period last year. Hope this explains the situation.