Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello again community.
I think this very simple, but I cannot reach this outcome using Power Query (Add Custom Column feature). Cal you help me?
In one table I have Columns:
DAY = 01;
MONTH = 01, 02, 03 and so on;
YEAR = 2016
Outcome: A Custom column that joins all three columns above and shows in date format DD-MM-YY (01-01-2016, 01-02-2016, 01-03-16
I have tried M lamguage = [DAY] & "-" & [MONTH] & "-" & [YEAR]
Result I got = Error
Thanks again in advance people.
Solved! Go to Solution.
I just tried this and it worked like a champ. I made sure that all of my columns were Text though so perhaps that is your issue?
[Day] & "-" & [Month] & "-" & [Year]
Here is the query I used:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjBU0oEQRgaGZkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Day = _t, Month = _t, Year = _t]), #"Added Custom" = Table.AddColumn(Source, "Custom", each [Day] & "-" & [Month] & "-" & [Year]) in #"Added Custom"
I recently needed to create a custom column in Power Query that detected if an invoice was before July 6, 2020. This code works and looks a bit simpler than the previous answers.
= [InvoiceDate] < Date.FromText("7/6/2020")
I just tried this and it worked like a champ. I made sure that all of my columns were Text though so perhaps that is your issue?
[Day] & "-" & [Month] & "-" & [Year]
Here is the query I used:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjBU0oEQRgaGZkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Day = _t, Month = _t, Year = _t]), #"Added Custom" = Table.AddColumn(Source, "Custom", each [Day] & "-" & [Month] & "-" & [Year]) in #"Added Custom"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |