Hi, I'm trying to create a formula in DAX for:
If location ="9000"
And the date is between 4/1/18 and 6/30/18
Then take the SALES_GOALS[LY CORE]*1.5
=if(AND(SALES_GOALS[STORE]="9000",SALES_GOALS[LAST YEAR DATES (Month)]="apr"),SALES_GOALS[LY CORE]*1.5,SALES_GOALS[LY CORE]*1.1)
I've got it working if the month="Apr"
But need to have different sales goal increase for different months.
Can you suggest a formula?
Also would I be better to have a helper table that would contain the increases.
IE 9000, May, June x 1.5
Aug x 1.8....
Thanks
If location ="9000"
And the date is between 4/1/18 and 6/30/18
Then take the SALES_GOALS[LY CORE]*1.5
=if(AND(SALES_GOALS[STORE]="9000",SALES_GOALS[LAST YEAR DATES (Month)]="apr"),SALES_GOALS[LY CORE]*1.5,SALES_GOALS[LY CORE]*1.1)
I've got it working if the month="Apr"
But need to have different sales goal increase for different months.
Can you suggest a formula?
Also would I be better to have a helper table that would contain the increases.
IE 9000, May, June x 1.5
Aug x 1.8....
Thanks