Measure to partially allocate monthly value

[ilovasen]

Hi

Is there an easy way to make a measure that allocates 50% of the Feb value in the table below into Jan and keep the remainder of Feb in Feb (the remaining months are not to be altered)?

Brgds,
Inge

Month - Value
Jan - 0
Feb - 4
Mar - 3
Apr - 1
May - 2
Jun - 2
Jul - 2
Aug - 3
Sep - 2
Oct - 3
Nov - 1
Dec - 1

 

[dermie_72]

in the cell that hold the 0 next to jan
put = then press the down arrow, then /2

that will make the formula divide feb by 2 and wont touch any other cell.

 

[scottsen]

Maybe something like this?!

=IF(HASONEVALUE(Table[Month], 
           IF(VALUES(Table[Month]) = "Jan", 
                    [Measure] + CALCULATE([Measure], Calendar[Month] = "Feb") / 2,
                    [Measure]
           )
     )

 

[ilovasen]

Thanks to dermie_72 and scottsen for responses. Really great to see that you have solved this for me during my vacation.
It is really inspiring to see that there are solutions to just about all problems.
With great appreciation, Inge