calculated column based on time dimension

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 comment
  • 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) ...

Please sign in to leave a comment.

Didn't find what you were looking for?

New post