How to Get the Maximum Condition-Based Logging of All Data

[Syndicate_Admin]

I have attached the test PBIX file as mentioned below.

Link to test PBIX file: https://1drv.ms/u/s!AiSRcgO5FUmN8w4UpKd5wMPcvPuI?e=rnLWaF

Test data:

In the test data above,

1) If I select the time "11:00 AM",

First, we need to filter each employee's unique time in the "DOJ" column maximum

Second, after filtering the maximum time, the "EmpStatus" filter is just OK.

If "EmpStatus" is Reject, that employee does not need to be considered.

Therefore, the final total of the records for "11:00 AM" is (1 record. (i.e.) Waugh ==> 10:45 AM). the other record of James's Empstatus is Reject. so there's no need to consider Jame's track record. This is until 11:00 a.m. of registration.

2) If I select the time "03:00 PM",

First, we need a unique filter for each employee in the maximum time of the "DOJ" column

Second, after filtering the maximum time, the "EmpStatus" filter is just OK.

Therefore, the final total of the records for "03:00 PM" is (1 record. (i.e.) again James' record should come ==> 02:42 AM). the other Waugh Empstatus record is Reject. so there's no need to consider Waugh's record. This is until 03:00 PM registration

In this way, we need to form the condition.

How to do this..?

[Anonymous · Accepted solution]

Hi Rakeshguptawe,

Based on your description, I added three visual filters:

And the Output:

Plesae check the pbix file.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group