Forum Discussion

Ka4ra's avatar
Ka4ra
New Member
2 years ago
Solved

How to change data (pivot? Group?)

I want to change the data format.   Below is sample data. Data has a same ID, Value but Col1 to Col7 some have data and some do not. I'm doing data transformation in Power BI, but I don't know wha...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Ka4ra ,

     

    Here are the steps you can follow：

    1. Create calculated table.

    Table2 =
SUMMARIZE(
    'Table',[Date],[ID],[VALUE],
    "Co1",MAX('Table'[Col1]),
    "Co2",MAX('Table'[Col2]),
    "Co3",MAX('Table'[Col3]),
    "Co4",MAX('Table'[Col4]),
    "Co5",MAX('Table'[Col5]),
    "Co6",MAX('Table'[Col6]),
    "Co7",MAX('Table'[Col7]))

    2. Result:

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Ka4ra ,

 

Here are the steps you can follow：

1. Create calculated table.

Table2 =
SUMMARIZE(
    'Table',[Date],[ID],[VALUE],
    "Co1",MAX('Table'[Col1]),
    "Co2",MAX('Table'[Col2]),
    "Co3",MAX('Table'[Col3]),
    "Co4",MAX('Table'[Col4]),
    "Co5",MAX('Table'[Col5]),
    "Co6",MAX('Table'[Col6]),
    "Co7",MAX('Table'[Col7]))

2. Result:

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly