topic Sum based on latest status in DAX Commands and Tips

Sum based on latest status

Anonymous — Tue, 31 Jan 2023 20:37:59 GMT

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

Re: Sum based on latest status

amitchandak — Wed, 01 Feb 2023 02:30:37 GMT

Anonymous , 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-f1c839ee884e

Re: Sum based on latest status

Anonymous — Wed, 01 Feb 2023 10:33:24 GMT

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.

Re: Sum based on latest status

FreemanZ — Thu, 02 Feb 2023 05:56:56 GMT

hi Anonymous

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

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