Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I'm wondering if someone can help me create a new table by summarizing the earliest price to the latest price. For example part 01247982. We want a table where it would show us a percent change from the 27.39 price to the 32 final price. We have a large list of vendors and we want to calculate YTD %'s instead of doing them individually. Please let me know if you have questions.
Item | Vendor | Vendor Name | Current Price | Final Price | Final Percent Change | Price Event ID | Final Effective Date |
01247982 | 13040880 | Test Vendor | $27.3900 | $29.170000 | 6% | 3/26/2021-Test Vendor | 5/18/2021 |
01247982 | 13040880 | Test Vendor | $29.1700 | 30.50 | 5% | 6/26/2021-Test Vendor | 7/1/2021 |
01247982 | 13040880 | Test Vendor | 30.50 | 32 | 5% | 9/26/2021-Test Vendor | 10/1/2021 |
01247993 | 13040880 | Test Vendor | $27.3900 | $29.170000 | 6% | 3/26/2021-Test Vendor | 5/18/2021 |
01247993 | 13040880 | Test Vendor | $29.1700 | 35 | 20% | 6/26/2021-Test Vendor | 7/1/2021 |
01247993 | 13040880 | Test Vendor | 35 | 40 | 14% | 9/26/2021-Test Vendor | 10/1/2021 |
01248004 | 13040880 | Test Vendor | $32.4700 | $34.580000 | 6% | 3/26/2021-Test Vendor | 5/18/2021 |
01248004 | 13040880 | Test Vendor | $34.5800 | 40 | 16% | 6/26/2021-Test Vendor | 7/1/2021 |
01248004 | 13040880 | Test Vendor | 40 | 50 | 25% | 9/26/2021-Test Vendor | 10/1/2021 |
01248015 | 13040880 | Test Vendor | $27.3900 | $29.170000 | 6% | 3/26/2021-Test Vendor | 5/18/2021 |
01248015 | 13040880 | Test Vendor | $29.1700 | 24 | -18% | 6/26/2021-Test Vendor | 7/1/2021 |
01248015 | 13040880 | Test Vendor | 24 | 35 | 46% | 9/26/2021-Test Vendor | 10/1/2021 |
01248026 | 13040880 | Test Vendor | $27.3900 | $29.170000 | 6% | 3/26/2021-Test Vendor | 5/18/2021 |
01248026 | 13040880 | Test Vendor | $29.1700 | 60 | 106% | 6/26/2021-Test Vendor | 7/1/2021 |
01248026 | 13040880 | Test Vendor | 60 | 40 | -33% | 9/26/2021-Test Vendor | 10/1/2021 |
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |