Replace BLANK with value from other row based on condition

[selvarajd1]

I would like to create a Custom Column formula that copies Product value( Azure Data Manager for Agriculture) within same Product column blank values . If PRODUCT is BLANK, then I want to find non-blank value for the same record Id 

Here's a graphical representation that I am looking for.

[SamInogic]

Hi @selvarajd1 ,

You can also try to create a custom column with below DAX expression,

Custom Column =

if(isblank( [Recordld] ) ,MAXX(FILTER('Sample', [Recordld] = EARLIER([Recordld]) && ISBLANK([Recordld])), [Recordld] ), [Recordld] )

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[selvarajd1]

Thank you, will check and revert with update..

[ValtteriN]

Hi,

Here is one way to do this:

data:

Dax:

Column =

var _id = 'Table (4)'[id]

var _nb = CALCULATE(MAX('Table (4)'[product]),ALL('Table (4)'),'Table (4)'[id]=_id) return

IF('Table (4)'[product]="",_nb,'Table (4)'[product])

End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[selvarajd1]

Thank you, will check and revert..