Forum Discussion

MNM's avatar
MNM
Frequent Visitor
3 years ago

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!

 

No RepliesBe the first to reply