Forum Discussion
Power BI Query for British Summer Time
Anonymous just wondering if you got anywhere with this please as I have the same issue.
Thanks!
Sadly not, Anonymous. The link above is the best solution I've found, but it's clumsy for my needs.
I haven't been able to ascertain if there's a way to update the original columns in a "replace value" sort of method. Otherwise, you have to repeat them to contain the calculated correct values separately. I already do a lot of time functions based on those columns so trying it is daunting.
watts_jimHelper II
Yes, there is a way to replace values:
https://learn.microsoft.com/en-us/powerquery-m/table-replacevalue
So your M language would have something like
#"New Step" = Table.ReplaceValue(#"Previous Step#,
each [DateTime],each <<< Some calculation or function >>> .
Replacer.ReplaceValue,{"DateTime]} )