Here's my table 'Approvals':
In my PowerBI report, I only want to display the Pending row if there IS NOT a matching FileID. If there is a matching FileID, I want to only show the LATEST row with that FileID.The rows that should display in the report are Index 1 and 3.
All assistance gratefully received.
Hi @annetoal ,
Create a calculated column with this code:
Proud to be a Super User!
I'm sorry, but I don't speak Spanish enough to understand your answer.
Can there be multiple approvals? If not then you can simply show all rows where FileID is blank or status is approved.
Perhaps if you post a bit more sample data, it would help understanding the use case.
you can create a column like this
countx(filter(table,[Submitter]=earlier(Submitter) && [FileID] = earlier(FileID) && [Status] ="Approved"),[FileID])
You need to get all blank row for this column
Or try a measure like
countX(filter(summarize(table,table[FileID], "_1",count(table[FileID]),"_2", countx(filter( [Status] ="Approved"),table[FileID])+0),[_2]>0),[FileID])
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!