Forum Discussion
Week Number for Net due date
Hi Team,
Hope you can help me here.
I have a column for Fiscal Month, Fiscal Month End, Reporting Date, Net due.
Is there a dax that can add column to tag their week age based on Reporting and Net due date?.
Reporting date:
March 2023 Weekly Aging
1st Week: Feb 25-March 4
2nd Week: March 5-March 11
3rd Week: March 12-March 18
4th Week: March 19-March 25
5th Week: March 26-March 31
For April :
1st Week: April 1-April 8
2nd Week: April 9-April 15
3rd Week: April 16-April 22
4th Week: April 23-April 28
Net Due:
March 2023 Weekly Aging
1st Week: Feb 25-March 4
2nd Week: March 5-March 11
3rd Week: March 12-March 18
4th Week: March 19-March 25
5th Week: March 26-March 31
Current: Dates April 1 onwards
Carry Over Past Due: All dates before Feb 25
For April :
1st Week: April 1-April 8
2nd Week: April 9-April 15
3rd Week: April 16-April 22
4th Week: April 23-April 28
Current: Dates April 29 onwards
Carry Over Past Due: All dates before April 1
I am really having time with this.
Thank you!