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

calculated column based on time dimension

Avatar
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 Date Votes
  • Avatar
    Ole Dyring
    (Edited )

    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.

Didn't find what you were looking for?

New post