need to get previous row value in Matrix table if value is null

[MarshalSK]

Hi experts, Need to get previous row value only in Matrix table if value is null. Quick help will be helpful. Thanks in advance.

[Ritaf1983 · Accepted solution]

Hi  @MarshalSK
Please refer to the linked discussion, the solution of @v-angzheng-msft:

https://community.fabric.microsoft.com/t5/Desktop/Fill-down-colum-based-on-latest-value/td-p/1753842

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

[Ritaf1983 · Accepted solution]

Hi  @MarshalSK
Please refer to the linked discussion, the solution of @v-angzheng-msft:

https://community.fabric.microsoft.com/t5/Desktop/Fill-down-colum-based-on-latest-value/td-p/1753842

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[MarshalSK]

That's in power query which will affect base data, I need a measure calculation should affect only Matrix Table. 

[Ritaf1983 · Accepted solution]

Hi @MarshalSK 
There is a Dax solution too...

[MarshalSK]

Thanks for reply let me check.