Forum Discussion

Dimani's avatar
Dimani
Icon for Helper II rankHelper II
3 years ago

Formatting multiple columns at the same time?

Hello   In Power Query, is it possible to format multiple columns/fields at the same time.  We will be using the same format for all those interested columns/fields, and all of them are numeric fie...
Need Help
Dimani's avatar
Dimani
Icon for Helper II rankHelper II
3 years ago

Thanks for your information.  We were wishing there was an easier way.  I will discuss this with my colleague to see if we want to use this approach, knowing that when we need to perform calculation, we will need to convert the data back to numeric.

ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper User
3 years ago

In general, I think of PQ as something used to shape your data, and Power BI to display formatted reports. Trying to do the formatting in PQ would be an inefficient use of the tool.