I am new to PowerBi and have questions regarding dynamic filtering based on datetime slicer . Say I have the following table:
Based on the date range(TableDateTime) I select from the slicer in powerbi i want to do the following :
If ApprovalInNumber. > 0 && if TimesApproved > 1 Get all the columns with Max(Rev) for this Id where Approvals/Rejects = Approve.
If ApprovalInNumber. < 1 Get all the columns with Max(Rev) for this Id where Approval/Rejects = Reject .
I would want to do this for all duplicate Id's . How can i achieve this dynamically based on the date range slicer . Any help is much appreciated