Forum Discussion
Help with dynamic format strings
Hope somebody can point me in the right direction regarding dynamic formatting. I have this table: Period KPI Code KPI value Data Type Jun-24 PC008 2.12 Number ...
Looks like what I want to do is not possible. All of my numbers are decimal when they are loaded into Power Query. The only way of determining which one's need to be displayed as a % and which as a whole number, is by referencing the 'Data type' column. There doesn't seem to be a way of using format strings that reference other columns. So, at the moment there is no solution to this. Thanks for everybodies help though.
Hello agian Fusilier2 ,
I'm glad you found a solution and were able to resolve the query. Thank you very much for sharing your findings here. It’s helpful for others facing a similar issue.
If you have any further queries, please don’t hesitate to reach out.
Thankyou for connecting with Microsoft Community Forum