Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need your advice how to edit the query.
I received 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
Solved! Go to Solution.
PFB the attachment for reference.
Accept solution if it resolves your requirement.
hi @KYOSHIKAWA
For your case, you could use solution as labuser1235 provided, and you'd better add a year column and in the two tables and add this conditional in LOOKUPVALUE Function.
For example:
Regards,
Lin
hi @KYOSHIKAWA
For your case, you could use solution as labuser1235 provided, and you'd better add a year column and in the two tables and add this conditional in LOOKUPVALUE Function.
For example:
Regards,
Lin
Thank you for your advice.
In my Power BI, lookupvalue function was not recognized...
I will check it again.
And I will check the site which you told the link.
Best regards,
Yoshi
PFB the attachment for reference.
Accept solution if it resolves your requirement.
Thank you for your advice.
Your editted query is useful.
However "lookupvalue" function was not recognized in my Power BI...
Anyway thank you for your support.
Best regards,
Yoshi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |