Forum Discussion
Multiple filters on same table
Hi, I have a requirement to filter out items to find Count of items based on below criteria. It would be running report hence quarter would change each time.
It is to find on hand items without decision at beginning of quarter
Type - need to filter out Types - CC and CD
Received Date - Till last quarter(< 01/04/2023)
Decision Date - Null and Decision taken after 01/04/2023
My table looks as below.
I have the below filter but I can't add anything to find the beginning of last quarter logic to it. Any help appreciated.
Libin7963 , Have date table and following log Like my HR blog, Current Employee, add an additional filter as per need
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970Sample files are attached after signature
1 Reply
Libin7963 , Have date table and following log Like my HR blog, Current Employee, add an additional filter as per need
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970Sample files are attached after signature