Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Mars3442
Helper I
Helper I

Replace only null value and 1 condition

Hi everyone,

I want to ask a help for solving my problem

I have a table like this

Screenshot_20231107_181227_Sheets.jpg

I need to replace the null value with these conditional :

Order = Arrive, the status = delivered

Without replace the cell that have been filled

 

My expectation table like this

Screenshot_20231107_182221_Sheets.jpg

 

But when I write the M code

= Table.ReplaceValue (#stepbefore, each [Status], each if [Status]=null and [Order qty]=[Arrive qty] then "Delivered", else[Status], Replacer.ReplaceValue,{"Status"})

 

There is nothing change

 

Please help me to solve this problem

 

Thank you..

 

1 ACCEPTED SOLUTION
AlienSx
Super User
Super User

Hello, @Mars3442 try custom replacer function

Table.ReplaceValue(
      stepbefore, 
      "", 
      each ([Order Qty] = [Arrive qty]) and ([Status] = null),
      (value, old, new) => if new then "Delivered" else value, 
      {"Status"}
)

View solution in original post

1 REPLY 1
AlienSx
Super User
Super User

Hello, @Mars3442 try custom replacer function

Table.ReplaceValue(
      stepbefore, 
      "", 
      each ([Order Qty] = [Arrive qty]) and ([Status] = null),
      (value, old, new) => if new then "Delivered" else value, 
      {"Status"}
)

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors