Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

table transformation

Hi everyone, I have a table like in the example below I would like to transform it this way can someone help me?
General Comment
Need Help
dufoq3's avatar
dufoq3
Community Champion
2 years ago

Hi, provide sample data as table so we can copy/paste. Don't forget to describe what exactly you want to do with the data. Don't forget to provide also expected result based on sample data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank,

    there the data.

    MeseJan-24
    WBSRevenueCostDelta EAC RevenueDelta EAC
    Cost
    P.00434.1.124,000.00 €  2,800.00 €  -   €  -   € 
    P.00615.1.0119,000.00 €  15,000.00 €  -   € -
    P.00906.1.018,700.00 €  8,000.00 €  -   €  -   € 

     

    and here's what I expect

    datacommessa RevenueCostDelta EAC RevenueDelta EAC
    Cost
    1/1/2024P.00434.1.124.000,002.800,0000
    1/1/2024P.00615.1.015000200000
    1/1/2024P.00906.1.018,700.00 €  8,000.00 € 00
    • dufoq3's avatar
      dufoq3
      Community Champion
      2 years ago

      Ok, so you want transform from this

      to this

      but you forgot DESCRIPTION!!!!

      1. I see that you renamed WBS to commensa
      2. what about [data] column in result? I don't see such column in Source
      3. there are changes in Revenue and Cost but how?
      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi dufoq3 ,

        I'm sorry, I'll write in detail what I have and what I expect.

        I have this table that is compiled by hand on sharepoint by my management, unfortunately the format is decided by them for a question of visibility and their convenience.

        MeseJan-24
        WBSRevenueCostDelta EAC RevenueDelta EAC
        Cost
        P.00434.1.124000.002800.000.000.00
        P.00615.1.0119000.0015000.000.000.00
        P.00906.1.018700.008000.000.000.00

        I would like to transform it into this format to have the possibility of better managing the data in power bi desktop and I would like to do this by transforming the data directly into power query

        MeseWBSRevenueCostDelta EAC RevenueDelta EAC
        Cost
        1/1/2024P.00434.1.124000.002800.000.000.00
        1/1/2024P.00615.1.0119000.0015000.000.000.00
        1/1/2024P.00906.1.018700.008000.000.000.00

         

        This format is necessary for me to create graphs and formulas in dax later. This is what I think but there may also be a better solution, I'm open to any advice.

        Thank you and sorry for the misunderstanding