Number of Days fall on weekday

[PowerBIOrg]

Hi All,

I would like to count number of days fall on certain day (Sun, Mon, etc) providing StartDate and EndDate.

The following is the data structure:

I expect the output as following:

1) Filtered Date: 2022-08-01 to 2022-09-30:

2) Filterd Date: 2022-09-01 to 2022-09-10

Thanks!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure about the result that is shown in your sample, but please check the below picture and the attached pbix file.

It is for creating a measure.

Expected result measure: =
SUMX (
    Data,
    CALCULATE (
        COUNTROWS (
            FILTER (
                'Calendar',
                'Calendar'[Date] >= MAX ( Data[StartDate] )
                    && 'Calendar'[Date] <= MAX ( Data[EndDate] )
            )
        )
    )
)

[PowerBIOrg]

Hi, 
what if the duration in decimal places? and I would like the decimal place count in start date. 

Thanks!

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the attached file.

Thank you.

[PowerBIOrg]

Hi, is there anyway that can do this without creating another calculated table? I worry there will be performance issue. 

[Jihwan_Kim]

Hi,

Thank you for your message.

Please check the attached file.

I tried to add two more measures and created a table visualization by only using two measures, and without using a physical-calculated-table.

Please kindly check if the result shows correct numbers or not.

Thank you.