Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Modifying report

Hi , i have a requirement to complete in Power Query.

 

Given scenario is this ,

 

 

Output Required is this : 

 

Period      |  Exchange rate(euro)   |  Exchange rate(usd)  |

4/1/2019            77.05                             68.7

 

and the other values are continued below.              Period , exchange rates should be the column headers.

 

Is this possible in Power Query? I can't use DAX as i still need to model the data further , any help would be appreciated.

Data Modeling
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    If you can add an index column like below, then you can use python script to meet your requirement.

     

     

    # 'dataset' holds the input data for this script

import pandas as pd

dataset = dataset.pivot(index = 'Index', columns = 'Column1', values = 'Column2')

      

     

    Community Support Team _ Jimmy Tao

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

     

  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    On the attached, you will find a solution using Power Query, if you have an extra ID column that could be used to group these 3 records together then skip prior steps and jump straight to Grouped Rows step.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    Anonymous ,

     

    If you can add an index column like below, then you can use python script to meet your requirement.

     

     

    # 'dataset' holds the input data for this script

import pandas as pd

dataset = dataset.pivot(index = 'Index', columns = 'Column1', values = 'Column2')

      

     

    Community Support Team _ Jimmy Tao

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

     

    • Mariusz's avatar
      Mariusz
      Community Champion
      6 years ago

      Hi Anonymous 

       

      On the attached, you will find a solution using Power Query, if you have an extra ID column that could be used to group these 3 records together then skip prior steps and jump straight to Grouped Rows step.

       

      Best Regards,
      Mariusz

      If this post helps, then please consider Accepting it as the solution.

      Please feel free to connect with me.
      LinkedIn