Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |