Forum Discussion
mmowrey
Helper I
Helper IDays till expiration
I have a report that i want to know how many products expire from today, grouping by 0 (this week), 1,2,3,4,5,6.
I have a field, expriation date
You could add a column like this that calcs the weeks between today and the expiration date.
Exp Week = DATEDIFF(TODAY(),'Table'[expiration date],WEEK)
1 Reply
- jdbuchanan71
Super User
You could add a column like this that calcs the weeks between today and the expiration date.
Exp Week = DATEDIFF(TODAY(),'Table'[expiration date],WEEK)