Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am creating a condiitonal column and want the output to be date, i was using this #date(2023, 9, 1) as syntax in the output column and formatted the new column as date, for some reason the column in throwing an error. What could be wrong.
Solved! Go to Solution.
Thanks for the additional info. You can do something like this...
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8nL0U4rViVZyc3UC076OQWDaMSAIyo8E016hflDaByIf6g6mg10DwLS/cwiY9vMPA9Murs5KsbEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Month = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Month", type text}}),
DateFromMonth = Table.AddColumn(#"Changed Type", "Date",
let
strMonths = {"JAN", "FEB", "MAR", "APR", "MAY", "JUN", "JUL", "AUG", "SEP", "OCT", "NOV", "DEC"}
in
each
try
let intMonth = List.PositionOf ( strMonths, [Month] ) + 1 in
Date.ToText ( #date(2023,intMonth,1), "dd-MM-yyyy" )
otherwise null, type text
)
in
DateFromMonth
@Sudi Have you had a chance to look at the solution provided? Please consider clicking Accept as Solution if this answered your question or solved your problem. Thanks!
Thank you Jen, Posting more details if that helps
Thanks for the additional info. You can do something like this...
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8nL0U4rViVZyc3UC076OQWDaMSAIyo8E016hflDaByIf6g6mg10DwLS/cwiY9vMPA9Murs5KsbEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Month = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Month", type text}}),
DateFromMonth = Table.AddColumn(#"Changed Type", "Date",
let
strMonths = {"JAN", "FEB", "MAR", "APR", "MAY", "JUN", "JUL", "AUG", "SEP", "OCT", "NOV", "DEC"}
in
each
try
let intMonth = List.PositionOf ( strMonths, [Month] ) + 1 in
Date.ToText ( #date(2023,intMonth,1), "dd-MM-yyyy" )
otherwise null, type text
)
in
DateFromMonth
Hello - it's difficult to say what's wrong without seeing the error message being thrown or the condition and data. That being said, I would guess that the problem may be the data type like one or more of the below reasons:
If you need further assistance, please post some sample data along with your script and the error message being generated.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
39 | |
24 | |
21 | |
21 | |
13 |