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.
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
Solved! Go to Solution.
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=1
then, 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 0
then 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.
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=1
then, 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 0
then 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.
@Anonymous , Try a measure like
calculate(count(employee[employee id]), filter(employee, weekday(employee[join date],2) =1))
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |