Forum Discussion
double format for a single column
Hi, I assume that you dont want to summarize the column, right ? (you you do, I would suggest that you convert with conditional column everything to hours (if contains ":", then multiply by 24, and next add":00").
But if you want just to adjust the format in one column, you could add a calculated column (just simply formatted column = original column, which would use dynamic formatting, for which you would create a condition, that if it contains ":" then format as hours, if not, then format as days....
In other words, if in excel i have this data
4
5:30
12:00
2
Suppose i just load these data in power query and then reload it in excel.
I'd like to have 2 different format in the column, number and hours, with this istruction i have it on power query but when i reload the data in excel it doesnt keep the format
=Table.TransformColumns(PrevStep, {"data", each try Time.From(_) otherwise Number.From(_)})