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

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