Calculation depending on selected month

[Anonymous]

Hi guys,

I have table with a coumn vor a value and a date table.

Now I'd like to multiply the value with 13 when in date slicer selected month is Jan to October..

When November and December is selected I'd like to multiply the value *12

May you help me out with this thing?

Thank you very much in advance?

David

[lbendlin · Accepted solution]

@Anonymous 

[Value]*(13-IF(MONTH([Date]) IN {11,12},1,0))

[Anonymous]

Hello @lbendlin 

Thank you very much! Have tried a lot around with IF before to get the solution. Now I understand my problem better. Using IF I have to create a column. But at moment I don't have access to tabular model which I use for report.

Is it possible to get the expected value (basisvalue x *12 when month is 1,2,3,4,5,6,7,8,9,10, and *13 when month is 11,12) on another way?

[lbendlin]

This should work in a measure too.