Forum Discussion

MichaelG1117's avatar
MichaelG1117
Helper I
2 years ago

Creating WEEKING ENDING NUMBER Directly Into a Date Table

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...

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

    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] ))