su
2 Topics
sum by mainItem
Hi, What I thought would be an easy tasked proved more complex then I thought Table A itemSK count a 5 b 5 c 6 d 6 a 7 b 6 b 1 d 3 Item table ItemSK Mainitemid a o b o c p d p Result Item Count by mainitem a 24 b 24 c 15 d 15 Help me write dax for "Count by mainitem" please 🙂 I could give you all my filed attempts but i don't think it will help(?) regardsSolved2.1KViews0likes3CommentsSubtract total from previous values
Hi, I've a table with packageid and expiry date. How to get a total of values where we can substract with the previous value? I need the values in new balance where it filter the max [update] then take the balance minus with [qty]. The next line of it will subtract the previous value according to the chronological [update] with their respective [packageid] and [expirydate]. Notice that in [packageid] for 0901, it has different expirydate so the new balance won't subtract the previous value. TQ! packageid expirydate update qty balance new balance 8875 03/08/2020 09/07/2020 90 100 100-90=10 8875 03/08/2020 09/06/2020 6 100 100-90-6=4 8875 03/08/2020 31/03/2020 1 100 100-90-6-1=3 8875 03/08/2020 21/01/2020 1 100 100-90-6-1-1=2 0901 31/12/2020 31/03/2020 1 1 1-1=0 0901 03/08/2020 31/03/2020 15 1 1-15=-14Solved1.6KViews0likes2Comments