First day of the week for fake week




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? 




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




    Miz Logix

  • 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! 

  • @wskagegard 


    Awesome! Glad that you figured it out