variation
2 Topics
% Variation
Hey all, I want to calculate the % variation of a stock, but I am having trouble to lock it's earliest and lastest value to perform my calculation. Stock MaxDate year-month Value A 7/31/2022 Jul-22 14 A 8/31/2022 Aug-22 15 A 9/30/2022 Sep-22 15 A 10/31/2022 Oct-22 12 A 11/30/2022 Nov-22 16 B 7/31/2022 Jul-22 74 B 8/31/2022 Aug-22 65 B 9/30/2022 Sep-22 64 B 10/31/2022 Oct-22 67 B 11/30/2022 Nov-22 80 C 7/31/2022 Jul-22 110 C 8/31/2022 Aug-22 105 C 9/30/2022 Sep-22 90 C 10/31/2022 Oct-22 110 C 11/30/2022 Nov-22 85 Besides this table, there is also a Calendar table that is connect by a Date column. For Stock A I always want to Initial Value to be = 14. Then, as the months go by I want to: August % = (15-14)/14 September = (15-14)/14 October = (12-14)/14 November = (16-14)/14 How can I do this? Thanks!Solved1.3KViews0likes7CommentsWeek over Week change for the same document
Hello guys! I have a table called "OPEN POs" that looks like this: WeekNum Supplier PO number Payment term 33 A 158 30 days 33 C 105 60 days 33 Y 469 30 days 33 A 422 90 days 33 Y 789 75 days 33 U 156 120 days 33 Y 111 45 days 34 A 158 60 days 34 C 105 60 days 34 T 88 90 days 34 Z 156 120 days 34 U 777 120 days 34 B 879 45 days 34 Y 789 45 days 34 U 156 120 days I'm trying to build a matrix like this: Week 34 PO number Supplier From To 158 A 30 days 60 days 789 Y 75 days 45 days The idea is to show the "PO numbers" that had its "Payment term" changed from one week to another. The variation always needs to be from the current week (that will be selected on the slicer) versus the previous week. Can you guys please help me on this one? mahoneypat ideas? 😁 😬 Thank you for the support! 🙂Solved1.9KViews0likes7Comments