topic Re: Replace BLANK with value from other row based on condition in DAX Commands and Tips

Replace BLANK with value from other row based on condition

selvarajd1 — Mon, 11 Sep 2023 21:30:43 GMT

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.

Re: Replace BLANK with value from other row based on condition

ValtteriN — Tue, 12 Sep 2023 06:04:33 GMT

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/

Re: Replace BLANK with value from other row based on condition

SamInogic — Tue, 12 Sep 2023 06:19:52 GMT

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/

Re: Replace BLANK with value from other row based on condition

selvarajd1 — Tue, 12 Sep 2023 17:07:51 GMT

Thank you, will check and revert with update..

Re: Replace BLANK with value from other row based on condition

selvarajd1 — Tue, 12 Sep 2023 17:08:17 GMT

Thank you, will check and revert..