topic Re: Number of Days fall on weekday in DAX Commands and Tips

Number of Days fall on weekday

PowerBIOrg — Fri, 23 Sep 2022 03:26:47 GMT

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!

Re: Number of Days fall on weekday

Jihwan_Kim — Fri, 23 Sep 2022 03:16:32 GMT

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] ) ) ) ) )

Re: Number of Days fall on weekday

PowerBIOrg — Mon, 26 Sep 2022 02:53:42 GMT

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

Thanks!

Re: Number of Days fall on weekday

Jihwan_Kim — Mon, 26 Sep 2022 04:25:29 GMT

Hi,

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

Thank you.

Re: Number of Days fall on weekday

PowerBIOrg — Mon, 26 Sep 2022 06:22:10 GMT

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

Re: Number of Days fall on weekday

Jihwan_Kim — Mon, 26 Sep 2022 06:45:45 GMT

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.