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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors