Forum Discussion
Visualizing each distinct row by latest date
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!
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
2 Replies
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"
