First day of the week for fake week

wskagegard
wskagegard
in Academy Discussions

Hi,

 

I have calculations in a module with time day and the calendar type is calendar month. I have created fake weeks and needs to calculate first day of the week and last day of the week. Havent found a good solution for that. Does anyone have an idea? 

 

 

Comments

  • Misbah
    Misbah

    @wskagegard 

     

    Do you have any rough template (excel format) how you expect it to work. There could be a lot of assumptions here.

     

    We can certainly do it once you share more info.

     

    Thanks,

    Misbah

    Miz Logix

  • wskagegard
    wskagegard

    I think I solved it myself. I used a WEEKDAY(Date) in a time dimension and then transferred that to fake day and then looked up which one was the monday and usnday. Thanks Anyway! 

  • Misbah
    Misbah

    @wskagegard 

     

    Awesome! Glad that you figured it out

Categories