measure - Count nº of week days between two dates using direct query mode

[Duartegarcia]

Hi all,

I am trying to create a measure in Power Bi, but I am having difficulties to get the result I want.

I want to count the nº of weekdays between two dates in the same table using direct query mode.

The measure I wanted to create is something like this 

Measure = CALCULATE([Week Days]);DATEDIFF(MIN('Table1'[PeriodBegin]);MAX('Table1'[PeriodEnd]);DAY))

The measure 'Week Days' counts the number of days in a column(WeekDay) within Date table that is "1" in a weekend day and "0" in a week day. So measure 'Week Days' counts all the "0"s

I want to get the nº of week days within this analysis between the oldest date (Min Period Begin) and the newest date (Max Period End)

An issue I found using Direct Query Mode is that is not possible to use the "DatesBetween" and "FirstDate" functions.

Please help 😉

Thanks

[Duartegarcia]

Hi all,

I am trying to create a measure in Power Bi, but I am having difficulties to get the result I want.

I want to count the nº of weekdays between two dates in the same table using direct query mode.

The measure I wanted to create is something like this 

Measure = CALCULATE([Week Days]);DATEDIFF(MIN('Table1'[PeriodBegin]);MAX('Table1'[PeriodEnd]);DAY))

The measure 'Week Days' counts the number of days in a column(WeekDay) within Date table that is "1" in a weekend day and "0" in a week day. So measure 'Week Days' counts all the "0"s

I want to get the nº of week days within this analysis between the oldest date (Min Period Begin) and the newest date (Max Period End)

An issue I found using Direct Query Mode is that is not possible to use the "DatesBetween" and "FirstDate" functions.

Please help 😉

Thanks

[AkhilAshok]

Have you tried enabling this options: Options & Settings -> Options -> DirectQuery -> Allow Unrestricted Measures in DirectQuery mode