Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Auto-Filter Tables Based on Date in Column

I am still relatively new to Power BI, so please forgive me if this is a simple question; I have been looking for a solution for days and haven't been able to find an answer. This is also my first ti...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi Anonymous ,

     

    You can modify the paycode at underlined section and create a new measure.

    I have modified the demo, please try it:demo.pbix

     

    Best Regards,

    Link

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

For your date format, are you using MM/DD/YYYY or DD/MM/YYYY?

I can see your measure is counting on the demo, but it's still not filtering out the dates after Ted recieved his corrective action on 11/3/2020 (MM/DD/YYYY). It is still showing dates from the months prior to November.

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

There @HRBIs832

When i drag the measure into the table, it works.

v-xulin-mstf_1-1610525251489.png

Best Regards,

Link

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Okay, I got it working! Is there any way I can have it look for multiple pay codes or should I just do a different measure for each?  For example, currenlyt it looks for Pay Cod=Leave of Absence and counts those, is there a way to, for instance, count both the Leave of Absence pay code and others, such as Military Leave?

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    You can modify the paycode at underlined section and create a new measure.

    I have modified the demo, please try it:demo.pbix

     

    Best Regards,

    Link

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    That's exactly what I was looking for! Thank you so much for all your help!