Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have an excel file in my Power BI workbook that has repeat values for the primary ID, Org Code. It's a unique ID assigned to each company, shown below
My objective is to create a measure which calculates the latest (maximum) submission date for a company when the Process Step is Approval, Upload, or Resubmission. Shown below is the excel version of this calculation, and what I'd like to have in Power BI
Here's the code I have tried -- believe I might have an erorr somewhere as it doesn't work... I want the MAX of the three upload approval resubmission for each unique org code
Solved! Go to Solution.
Hi @Anonymous ,
Check the measure.
Measure = CALCULATE(MAX('Table'[date]),FILTER(ALLEXCEPT('Table','Table'[id]),'Table'[step]<>"rejection"))
Best Regards,
Jay
Hi @Anonymous ,
Check the measure.
Measure = CALCULATE(MAX('Table'[date]),FILTER(ALLEXCEPT('Table','Table'[id]),'Table'[step]<>"rejection"))
Best Regards,
Jay
@Anonymous , Try like
Latest Submission Date = CALCULATE(MAX('Approval Process Audit Log'[Status Change Date]), FILTER('Approval Process Audit Log','Approval Process Audit Log'[Process Step] in{ "Upload" , "Approval" , , "Resubmission"}))
Latest Submission Date = CALCULATE(MAX('Approval Process Audit Log'[Status Change Date]), FILTER('Approval Process Audit Log','Approval Process Audit Log'[Process Step] in{ "Upload" , "Approval" , , "Resubmission"}) , allexcept('Approval Process Audit Log','Approval Process Audit Log'[Org_code]))
Hello @amitchandak -- thank you for the response. Would these measures be able to be added to a matrix table, or is that not possible? It appears to not let me add them as matrix table only accepts one column field, [Process Step] and doesn't let me use the new measure at all
@Anonymous , Are you trying for a hybrid table
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
99 | |
38 | |
37 |
User | Count |
---|---|
157 | |
121 | |
73 | |
73 | |
63 |