LastNonBlankValue ?

[Anonymous]

This is how the table looks like in Power BI.My goal is to fill up the blank comments (where IsCurrentVersion=1) with last non-null value for the same ID.

For example, the blank comment row for ID 6355  where IsCurrentVersion=1 should be populated with “Hi, Richard is asking for accedd on the Bed Capacity Tracking” site".

For ID 6360, latest row should remain blank because there’s no previous non-null value .

For 6362, latest row should be “Sent an MN to tier 2 for the ticket”

For 6379, latest row should be “Added roles for all”

To achieve this, I tried to use the LASTNONBLANKVALUE function. My formula is here :

Column = IF (‘’Sheet1’IsCurrentVersion]=1 && ‘Sheet1’ [Comments]="", LASTNONBLANKVALUE(' Sheet1'[Last_Modified],'sheet1'[_Comments]))

But this formula won’t work because my Date column is not standard. It doesn’t have all the dates in a year.

So I tried to add a custom column

Then fill up

Obviously that didn’t work either because it doesn’t understand the Grouping of ID’s. For example For ID 6360, latest row should remain blank because there’s no previous non-null value for that particular ID .

Can anyone advice on groupoing/ filling down or any other custom column method?

https://1drv.ms/x/s!Apg-ha77_EillQlnj2TCAhNPDhvg?e=zQ1w7Z 

[Anonymous]

no, the date is just being pulled from sharepoint. so the date column is not properly set up. can i acheive the solution with group by and fill?i have been trying but can't find a solution

[AlexisOlson]

Do you have a proper date table set up?

https://dax.guide/lastnonblankvalue/

In order to use any time intelligence calculation, you need a well-formed date table.

[Anonymous · Accepted solution]

This was solved here:

https://community.powerbi.com/t5/Power-Query/Help-with-pulling-up-latest-non-nullable-value-group-by...