Creating WEEKING ENDING NUMBER Directly Into a Date Table

[MichaelG1117]

Hi Everyone, 

Wondering if anyone knows how to create a WEEK ENDING NUMBER by date directly into the creating of a Date Table. 

This is what I have, but the Week Ending Number Column definitely isn't correct, "Week Ending By" is at the bottom.: 

 

 It just repeats the MAX date over and over again. 

 

Any help would be greatly appreciated. 

Thank you much...

[Jihwan_Kim]

HI,

I am not sure how your semantic model looks like, but try something like below whether it suits your requirement.

"Week End Num",
MAXX ( RELATEDTABLE ( 'Orders' ), 'Orders'[ShipDateKey] ))