Measure that is calculated differently for each month

DAX DAX Calculations
1

Apologies,
could not think of a better title.
I have two what if parameters in my report
Month1 (a number between -1.00 and +1.00 in increments of 0.01)
Month2 (a number between -1.00 and +1.00 in increments of 0.01)

I need to create a measure Sales Adjusted
Sales Adjusted = [Sales]
// if the Month is January and Jan Adj value is not 0
// then Sales * Jan Adj Value

// if the Month is Feb and Jan Feb is not 0
// then Sales * Feb Adj Value

This is for forecasting. The users want to be able to add a percentage to the current sales for a month. the percentage will change per month.

Thanks
E

2

@ells,

The SWITCH(TRUE)) construct is perfect for this type of scenario.

SWITCH True Logic Explained

  • Brian
3

@BrianJ
Many Thanks
E