topic Woule you mind telling me how to edit the query in this situation ? in Custom Visuals Development Discussion

Woule you mind telling me how to edit the query in this situation ?

Anonymous — Fri, 31 Jan 2020 02:45:36 GMT

I need your advice how to edit the query.

I reveived the table as excel file as below.

Date (Day/Month/Year) A (order) B(order) C(order)

1/1/2021 88 570 183

1/2/2021 86 550 170

1/3/2021 80 550 100

This table shows the "number of the products (A, B and C) for daily order".

Hence the number of products, which are written in the column at 1/1/2021, equals the number of products will be ordered everyday from 1st January 2021 to 31st January 2021.

I would like to edit the table by Power BI query as below.

The numbers of daily order will be written in each day.

Would you mind telling the method how to edit ?

I don't want to edit the excel file and hope to complete the edition of the table in query.

Date (Day/Month/Year) A (order) B(order) C(order)

1/1/2021 88 570 183

2/1/2021 88 570 183

31/1/2021 88 570 183

1/2/2021 86 550 170

2/2/2021 86 550 170

28/2/2021 86 550 170

1/3/2021 80 550 100

2/3/2021 80 550 100

Re: Woule you mind telling me how to edit the query in this situation ?

v-evelk — Tue, 04 Feb 2020 14:14:24 GMT

Hello,

Unfortunately, it's out of my expertise.

It's better to ask questions, related with data modelling, in an appropriate thread.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Woule you mind telling me how to edit the query in this situation ?

Anonymous — Thu, 06 Feb 2020 06:56:41 GMT

Dear Evgenii Elkin,

Thank you for your reply.

I will upload the question to the thread.

Best regards,
Yoshi