Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

LastNonBlankValue ?

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...

DAX Calculation

LASTNONBLANK

Anonymous
4 years ago
This was solved here:
https://community.powerbi.com/t5/Power-Query/Help-with-pulling-up-latest-non-nullable-value-group-by-ID/m-p/2238435/thread-id/66388/highlight/false#M66392

AlexisOlson

Super User

4 years ago

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

Not applicable

4 years ago

This was solved here:

https://community.powerbi.com/t5/Power-Query/Help-with-pulling-up-latest-non-nullable-value-group-by-ID/m-p/2238435/thread-id/66388/highlight/false#M66392

Forum Discussion

LastNonBlankValue ?

Related content

Dax - Optimise LASTNONBLANKVALUE

Running Total with LASTNONBLANKVALUE

DAX Get Second-to-LASTNONBLANKVALUE

DAX LastNonBlankValue

Lastnonblankvalues correspondence value