The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I want to create a new custom column by concatenating below 4 columns
Below screenshot shows the column name and final uid filed which is the desired output.
Thank you.
Solved! Go to Solution.
Hi, @Learner1585 [Code] goes last in your desired output
uid = Table.AddColumn(
your_table, "UID",
each [ID] & Text.From(Number.From([ActivityDate])) & Text.From(Number.From([Calendar Day])) & [Code]
)
Hi, @Learner1585 [Code] goes last in your desired output
uid = Table.AddColumn(
your_table, "UID",
each [ID] & Text.From(Number.From([ActivityDate])) & Text.From(Number.From([Calendar Day])) & [Code]
)