cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## 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

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

1 ACCEPTED SOLUTION
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
2 REPLIES 2
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Solution Sage

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

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors