Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculation depending on selected month

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 sel...
  • lbendlin's avatar
    lbendlin
    5 years ago

    Anonymous 

     

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Anonymous 

 

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    This should work in a measure too.