Sum based on latest status

[Shanze]

Hi All,

Need help with dax formula. So, my data has list of items that goes through two steps "Partial" & "Final". I want to somehow add values against all such items that are "Final" i.e., partial + final rows value and show it against latest status.

Whereas "Partial" rows should continue to appear as it is. 

Would appreciate any help. Thanks

[amitchandak]

@Shanze , Not very clear. But for latest status you can refer

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...

[Shanze]

Hi, so eloborating a bit. My data has a list of items that goes through capitalization in bits.

On partial completion a certain value of asset is capitalised as "Partial". There could be multiple partial values against any asset (items in my list) and once last time capitalisation is done it is "Final".

I want to make a dax function that assess each row and see if any item is marked final and change the status of all relevant rows to final. So, i may easily sum up values of partial + full.

And where final is not found in any row, it should be marked partial.

Hope it provides some clearity.

[FreemanZ]

hi @Shanze 

could you desensitize your data and provide a sample dataset with expected result?

p.s. consider @someone to continue a discussion.