Transform Table

[Joaquim_Guedes]

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

Kpi      Value

Kpi1    35%

Kpi2    26-10-2022

Kpi3   150,00€

Kpi4  1.050,00

Do I have to create a measure or a column to solve this problem? I have mutiple tables and columns with this situation. I can't chage data format in the data source files. Thank for your help.

Beste regards.

Joaquim Guedes

[v-shex-msft · Accepted solution]

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

[daXtreme]

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).