2 Replies Latest reply on Apr 9, 2013 1:28 AM by yulia.khazanova

    creating a new measure

    yulia.khazanova

      Hi everyone!

       

      I have the data with 2 seasons and each season has 5 episodes.

       

      I need to create new columns for each episode that will be representing the following condition:

       

      When SEASON is 1 and EPISODE is 1 then 1, else 0

      When SEASON is 1 and EPISODE is 2 then 1, else 0

      When SEASON is 1 and EPISODE is 3 then 1, else 0

      etc.

       

      When SEASON is 2 and EPISODE is 1 then 1, else 0

      When SEASON is 2 and EPISODE is 2 then 1, else 0

      When SEASON is 2 and EPISODE is 3 then 1, else 0

       

      Could you please help me to formulate the formula that I could use it in my calculated field?

       

      Thanks!