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

    Anonymous 

     

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

3 Replies

  • 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?