Forum Discussion
Data Filter for Monday Joining Employees
Hi All,
Need help me how to filter monday employee joining records, every day data loads into employees table who join on every day but i want data who joined on every monday.
Thanks
bharath
you can create a column by using the function WEEKDAY(<date>, <return_type>) to get the number identifying the day of the week of a date. FYI: https://docs.microsoft.com/en-us/dax/weekday-function-dax
weekday = WEEKDAY('Table'[Date],2)//return 1-7, monday=1then, create a measure filterMeasure, and drag the measure into the filters on this visual
filterMeasure = IF(SELECTEDVALUE('Table'[weekday])=1,1,0)//return 1 when weekday=1,else return 0then the visual will only show data of monday.
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Anonymous , Try a measure like
calculate(count(employee[employee id]), filter(employee, weekday(employee[join date],2) =1))
v-xiaotangCommunity Support
you can create a column by using the function WEEKDAY(<date>, <return_type>) to get the number identifying the day of the week of a date. FYI: https://docs.microsoft.com/en-us/dax/weekday-function-dax
weekday = WEEKDAY('Table'[Date],2)//return 1-7, monday=1then, create a measure filterMeasure, and drag the measure into the filters on this visual
filterMeasure = IF(SELECTEDVALUE('Table'[weekday])=1,1,0)//return 1 when weekday=1,else return 0then the visual will only show data of monday.
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.
