Forum Discussion
Power Query Custom Column with year and month
Hi to all, i try to add a custom column from my two date fields Start and End, but after, i got an error: Expression.Error: The value isn't a single-character string. Details: Value=202103 For c...
Solve my task with this code:
let Test = List.Distinct(List.Transform({[Start_Date__c],[End_Date__c]}, each Date.ToText(_, "yyyyMM"))) in Test
Solve my task with this code:
let
Test =
List.Distinct(List.Transform({[Start_Date__c],[End_Date__c]}, each Date.ToText(_, "yyyyMM")))
in
Test
Glad to your problem has been solved. Thank you for sharing.