Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |