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])
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.