Calculate Days based on a single filter

[edejes2]

Hello All, 

I am facing this issue as of now I am getting this results, but I need to be able to remove the weekends from this results. My days in the month should be 22 days.

=CACULATE(DATEDDIFF(MIN(Calendar_Table),ENDOFMONTH(Calendar_Table),DAY))

=DAY(ENOFMONTH(Calendar_Table)

I will appreciate any help provided.

Regards!

ED 

[v-yuezhe-msft]

@edejes2,

Your image is corrupted and I am unable to view it. Do you want to calculate working days based on selected values in date slicer? If so, please check the following DAX and example.

1. Create a column using dax below.

isworkingday = IF(WEEKDAY('Calendar Table'[DateKey])=1 ||WEEKDAY('Calendar Table'[DateKey])=7,0,1)

2. Create a measure using dax below.

Workingdays = var maxdate=MAX('Calendar Table'[DateKey])
var mindate=MIN('Calendar Table'[DateKey])

return 
SUMX (
FILTER (
'Calendar Table',
'Calendar Table'[DateKey] >=mindate
&& 'Calendar Table'[DateKey] <=maxdate),
'Calendar Table'[isworkingday]
)

Regards,

Lydia

[edejes2]

Hello @v-yuezhe-msft

I am grateful for your help! I forgot to mention that I am using SSAS and based on that I have some limitations. 

Regards!

ED

[v-yuezhe-msft · Accepted solution]

@edejes2，

If you use connect live connection, please create the isworkingday column in the SSAS data source.

Regards,
Lydia