Forum Discussion
How to apply transformations to multiple columns simultaneously in Power BI
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
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
2 Replies
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
