Forum Discussion

Joaquim_Guedes's avatar
Joaquim_Guedes
Frequent Visitor
3 years ago
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...
Table Column
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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