Forum Discussion
Cumulative Total
Is this what you are looking for?
Hey Anonymous ,
unfortunately, the sample data does not contain the columns you used in your posts. This makes it difficult to follow the previous discussion and trying to provide a solution.
Next to that, when I'm looking at the calendar table, the calendar week number does not contain the year number. For this reason it can become difficult. From your initial post the condition "delivery date <=today(week num)" seems to be not correct because you are comparing the delivery date with a weeknumber.
I'm also not sure what you mean by today, do you really mean Today or are you referring to the current data, when creating a visual referencing the Calendar table?
Not sure, but are you aware of the articles here: https://www.daxpatterns.com/time-patterns/
Consider explaining how the sample data relates to the available discussion.
Regards,
Tom
Hi TomMartens ,
Thank you for ypour response. Due to data security i am not able to share original data and thats why i created sample file with similar kind of columns.
As you mentioned in my first post I mentioned delivery date <= Today(Weeknum) , i actually mean to say
Delivery date<= Today() .
And in Visual I have tried couple of things in which i tried one calendar table by taking reference to Delivery Date column and create a Many to One relationship between Calendar Table (date) with ZIBP_PO_MATIN(Delivery date(date)) column .
Thanks,
Ashish