Akash has attended:
Power BI Modelling, Visualisation and Publishing course
Power Query M language
Hi,
In my Power Query I am trying to combine two Columns into a new Custom column, which replaces only 'Null' values in 'Column 1' with values in 'Column 2'.
E.g
Title Column 1 Column 2 Custom Column
Amazon PS4 PS4 Games PS4
SGM Null PS4 Games PS4 Games
How do I achieve this desired result using the Power Query 'M' Language?
I am referencing this query in another query, which is why I cannot do this as a 'Calculated Column' in the Data Tab.
Thanks in advance,
Akash
RE: Power Query M language
Hi Akash,
Thank you for the forum question.
If I understand what you want try:
=if [Column 1]=null then [Column 2] else [Column 1]
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector