Forum Discussion
Solved
double format for a single column
Hi to everyone, in Power Query i have a column that contains either days or hours, for example 4 5:30 12:00 2 and so on (what a crazy thing i know....) How can i properly format this column? I...
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....
hi zenisekd thank you for your answer but i am in Power Query, not in POwer Bi