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

    • dufoq3's avatar
      dufoq3
      Community Champion
      2 years ago

      I'm giving you last chance:

      Could you answer my question no 2 and 3 please?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi, dufoq3 

        Sorry but I have already reported the data in the correct format.
        2. what about [data] column in result? I don't see such column in Source: The date column is not there and it is called MESE as in the source table.
        3. there are changes in Revenue and Cost but how? the data have not changed, they are the same numbers for each WBS and each MESE
        I would like to bring the MESE row as a column before the WBS column, as described in the second table

        What else should I write to you?