Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
Hello everyone,
Here's my table 'Approvals':
Index | Submitter | Submitted_datetime | Status | Approved_datetime | FileID |
1 | Anne <removed by Admin> | 4/1/2020 13:00 | Pending | A1009 | |
2 | Anne <removed by Admin> | 4/9/2020 10:07 | Pending | A1001 | |
3 | Anne <removed by Admin> | 4/9/2020 10:07 | Approved | 4/10/2020 12:01 | A1001 |
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.
Sincerely,
Anne
Hi @annetoal ,
Create a calculated column with this code:
I'm sorry, but I don't speak Spanish enough to understand your answer.
Anne
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 April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
74 | |
70 | |
70 | |
45 | |
41 |
User | Count |
---|---|
51 | |
47 | |
32 | |
28 | |
27 |