Forum Discussion
Rubal
Helper II
Helper IINested 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 fact...
Hi Rubal
Better give an example with actual numbers.
It is hard to understand your requirements.
Thanks
A
RubalHelper II
Helper II
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.