1. TARGIT Community
  2. Community
  3. Data Warehouse Developer
Knowledge Base

calculated column based on time dimension

Kamma Westergaard ·

Hi all

How can I create a new calculated column based on the time dimension. From March 2020 to September 2020 the calculation should be 0 and for all the other months 1.

Thanks in advance      

1

Comments

1 comment
Sort by DateVotes
  • Ole Dyring

    Hi Kamma,

    I think you should be able to do it like this:

    The syntax is this:

    if allcount(d1, d1:0, m1) >= allcount(d1, d1:@"[2020].[Q1].[Mar]", m1) and allcount(d1, d1:0, m1) <= allcount(d1, d1:@"[2020].[Q3].[Sep]", m1) then 0 else 1

    Notice that your hierarchy reference should of course be slightly different, e.g.:

    ... allcount(d1, d1:@"[2020].[1. kvartal].[Marts]", m1) ...
    0
Please sign in to leave a comment.