Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Joaquim_Guedes
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
v-shex-msft
Community Support
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.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
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.
daXtreme
Solution Sage
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).

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.