topic Re: Transform Table in DAX Commands and Tips

Transform Table

Joaquim_Guedes — Wed, 16 Nov 2022 12:12:42 GMT

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

Re: Transform Table

daXtreme — Wed, 16 Nov 2022 13:54:08 GMT

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

Re: Transform Table

Anonymous — Mon, 21 Nov 2022 07:14:24 GMT

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