Forum Discussion
Running Total Week Calculation
Hi Community, I hope this will be simple question, im trying to achieve what is calculation in column marked yellow: So i have a table by Item number and by week...
OK, this will work pretty good while you have 1 item and week numbers dosnt duplicate. but what if table has many items and then many the same week's in column week of year. how can i tell power bi that im looking for this specific item context?
(if i apply this calculated column to data where more than one occurence of the same week exist then it crashes )
This is how it looks: So i would also need dax to know that we are looking at this item only and this week
Hi mhsk ,
Can you share a new sample that can be more accurate to display your model? Please share the pbix file if you can. Please mask the sensitive parts first.
Best Regards,
