cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
KYOSHIKAWA
Regular Visitor

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

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

2 REPLIES 2
Microsoft
Microsoft

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

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

KYOSHIKAWA
Regular Visitor

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

Dear Evgenii Elkin,

 

Thank you for your reply.

I will upload the question to the thread.

 

Best regards,
Yoshi

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors