Solved: Unable to replace null values in one column ?

suvechha · ‎09-28-2020

Hi there, Unable to replace null value in the column.

Sample model attached.

https://1drv.ms/u/s!AhqwbtIVEKQ2b8mGSC8la64lBLM?e=rEqmc3

CNENFRNL · ‎09-29-2020

@suvechha Generally speaking, that's a empty (zero-length) string instead of null (null is concrete value in PQ, which means "no value" for any data type).

You may try this

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

Icey · ‎09-30-2020

Hi @suvechha ,

Please let us know if the replies above are helpful.

If they are, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please give us more details.

Best Regards,

Icey

manikumar34 · ‎09-29-2020

@suvechha , update the below query in the formula bar

= Table.ReplaceValue(#"Duplicated Column","","Not Assigned",Replacer.ReplaceValue,{"Technician - Copy"})

If this works accept as solution and leave a like.

Regards,

Manikumar

If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

CNENFRNL · ‎09-29-2020

@suvechha Generally speaking, that's a empty (zero-length) string instead of null (null is concrete value in PQ, which means "no value" for any data type).

You may try this

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!