Shapes dates on single raws

[Anonymous]

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!

[PaulDBrown · Accepted solution]

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

sorry Paul, 

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

[v-shex-msft]

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

[PaulDBrown]

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

https://1drv.ms/u/s!AoM_DkwZfHBihnxYnUoAf4V5I3oe?e=mEGOyC 

[PaulDBrown]

@Anonymous 

Thanks but since the source is stored locally, I can't access the PQ steps. Can you try disabling the "Include in refresh" option (right click on the query and uncheck the option) or provide a sample dataset in an Excel file?

[Anonymous]

 This is the Excel Source split in Raw data and potential final solution: https://1drv.ms/x/s!AoM_DkwZfHBihn1g_LB3PHNbSeP5?e=d6KMGu 

Thanks Paul

[PaulDBrown]

@Anonymous 

Please provide a sample dataset to work on. (you can share a file from a cloud service (Onedrive, Dropbox, Google Drive...)

Thanks!