Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 bharat...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi @bharathpaturu33 

    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.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
5 years ago

Hi @bharathpaturu33 

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.