Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hey guys,
I've got two seperate columns containing "hour registration codes".
These two columns should be transformed into one.
If Column A (Ontvanger) is Null, the code is available in Column B (Aan/afw).
If Column B is Null, the code is available in Column A.
I thought I could fix this concatenating the two columns in Power Query.
The result was exactly the same as Column A though.
Any ideas on how to fix this?
With kind regards,
Lazzanova
Solved! Go to Solution.
NewStep=Table.AddColumn(PreviousStepName,"Concatenate",each List.RemoveItems({[Column A],[Column B]},{"",null}){0}?)
NewStep=Table.AddColumn(PreviousStepName,"Concatenate",each List.RemoveItems({[Column A],[Column B]},{"",null}){0}?)
User | Count |
---|---|
10 | |
8 | |
5 | |
5 | |
4 |