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.
Hi,
I have a simple excel table with three processes. There are target dates for these process by which they need to be finalized. Every month I add new rows to the table and update the process. If the process is in line with the plan, I put 1, if minor delay 2, and if major delay 3 in the status column. If the target is met for a specific process, then I will not update that the next month. For example, the target for the process A is in September and when I review that process in September (Update Date), I see that I have finalized that process. So, I do not need to update that in October. Now in Power BI, I want to show the final version of each process independent of the update month (the yellow rows in the pic). When I do that I want to see the latest of status column as well, not average or sum. I can filter the latest update month, but when I do that I only see Nov-20 for C and lose the latest status for A and B. Please C the picture for reference.
Any help is highly appriciated!
Thanks!
Solved! Go to Solution.
@SHKRV , Create a measure like this
Measure = CALCULATE(COUNT('Table'[process]) ,FILTER(('Table'),'Table'[update Date] =CALCULATE(max('Table'[update Date]),ALLEXCEPT('Table','Table'[process]))))
and use it with all non summarized columns
Thanks a lot for a quick reply.
It works perfect when I add this new measure to the table as a column. But I do not want to see that as a column in my table. Instead I added the measure to Filters section and selected "is not blank". It works fine.
Note: the name of my measure is "test"
@SHKRV , Create a measure like this
Measure = CALCULATE(COUNT('Table'[process]) ,FILTER(('Table'),'Table'[update Date] =CALCULATE(max('Table'[update Date]),ALLEXCEPT('Table','Table'[process]))))
and use it with all non summarized columns
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 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |