Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@edejes2,
If you use connect live connection, please create the isworkingday column in the SSAS data source.
Regards,
Lydia
@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
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
@edejes2,
If you use connect live connection, please create the isworkingday column in the SSAS data source.
Regards,
Lydia
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |