Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Shapes dates on single raws

Hi,    I have the following data model:     How can I  transpose the dates in to columns for Total_Quantity and Total_Price? It should be like this:     Thank you in advance!
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Anonymous 

     

    See if this works for you (BTW, where did you get the image for the expected result? It comes from a Query, does it not?)

     

    I'm not sure if there is a simpler way to do this, but I came up with a way which involves three different queries and a number of merges.

    I've attached the PBIX file for you.

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

 

See if this works for you (BTW, where did you get the image for the expected result? It comes from a Query, does it not?)

 

I'm not sure if there is a simpler way to do this, but I came up with a way which involves three different queries and a number of merges.

I've attached the PBIX file for you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    sorry Paul, 

     

    How can I open your Example.pbix? Unfortunately I have the following error:

    • PaulDBrown's avatar
      PaulDBrown
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Anonymous 

      Sorry about that. You need to point the the query to your source file (it's currently pointing at my hard drive).

      Use the option in the PQ ribbon "Data source settings" to change the source file

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      HI Anonymous,

      If your table structure is similar to the excel file which you share with 'PaulBrown', you can copy the raw report 'source' step to replace the shared sample file 'source' steps to fix the issue.

      Regards,

      Xiaoxin Sheng