Forum Discussion
Nested if with multiple conditions
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.
2 Replies
Hi Rubal
Better give an example with actual numbers.
It is hard to understand your requirements.
Thanks
A
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.
