Forum Discussion
Solved
Transform Table
I have multiples tables, with multiple columns. How can I transform the following table Table 1 Kpi Value Kpi 1 0,35 Kpi2 44860 Kpi3 150 Kpi4 1050 to this table Table 2 K...
Hi Joaquim_Guedes,
Current power bi does not support these, you can't store multiple type of data value in one field.
For your scenario, I think these should be suitable to create a parameter table with all categories to use in matrix and write a measure to return corresponding value based on current values.
Regards,
Xiaoxin Sheng
In short: you can't. Data in columns must be of the same type. So, either you're gonna turn everything into text (which can hold anything but it'll be text with all its limitations) or you're gonna turn the values into proper quantities on the fly (not recommended), or you're gonna change the structure of the table (create a new one, if you can't).