Skip to Content
author's profile photo Former Member
Former Member

[WebIntelligence] How to use correctly the Count Function?

Hey at all,

In my case I have a Start_date and an End_date. Now i want to extract the holidays. So I started to create another table with all oficial holidays in Germany. Then I created three dimensions Start_date_number, End-Date_Number and holiday_number. They write the date into an number(e.g. 2017.12.24 -> 20171224). With this transformation I think that its more easier to compare the dates. In a final step I created a measure which should count the quantity of the holiday_number between start_date_number and End_Date_Number.

My code looks like that:

=Count([Holiday_Number] Where ([Holiday_Number]>=[Start_Date_Number] And [Holiday_Number] <= [End_Date_Number]);All) ForAll ( [Holiday_Number] )

The result for any tuple is 0. So where is my error?

Add comment
10|10000 characters needed characters exceeded

0 Answers