Measure for dates in columns

[Anonymous]

Hello

I have a table like the below:

null, null, 01/01/2021, 02/01/2021, ...

Prod1, Price, 1, 2, 3, ....

Prod1, Quantity, 1, 2, 3, ...

Prod2, Price, 1, 2, 3

I want to create a measure to put in a graph where the x axis will be the dates and the y axis will be the Price of each Prod per date and another of the Quantity of each Prod per date.

Do I need to transpose the table?

Can you provide some ideas for the Measure please?

Thanks!

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You need to do some operations in the power query editor.

1. Select the two columns with empty headings, and then select merge columns.

2. After merging the first and second columns, select Transpose directly.

3. Add index column

4. Add the date column that was just lost in the conversion process.

5. Is this the output you expect?

If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

Best Regards,

Community Support Team _Charlotte

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

[lbendlin]

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.