How to apply transformations to multiple columns simultaneously in Power BI

[imik]

Hi there,

I have an Excel file with values in shortened millions. After using this file as a source for Power BI, I need to display them in their "real" values. One by one, I can manage this as suggested e.g. here: Solved: Change format from short Million into full million... - Microsoft Fabric Community

However, the number of columns is large, and I would prefer to apply this transformation to all of them at once. When I select all the columns, the 'Standard' option in a 'Transform' tab becomes greyed out.

Any ideas on how to solve this, please?

Tx in advance 🙏

imik

[OwenAuger · Accepted solution]

Hi @imik 

This function from Imke Feldmann at thebiccountant.com is useful for this.

Attached is a PBIX with a couple of small examples where I have applied this function to multiply multiple columns by 10^6.

• In Example1, the function is applied to a list of columns {"A","B","C"}
• In Example2, the function is applied to all columns except "Product".

Is something like this what you're looking for?

Regards

[imik]

Hi @OwenAuger,

Thank you so much for your explanation and for including the example!

I’m excited to start applying it to my case.

I really appreciate your help!

Best regards,

imik