Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Generate Dates

I want to create two measures that would generate the following date range for the current week and previous week. A new week starts on a sunday and ends on a saturday. I want the current week's date...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Please try these two measure expressions

     

    Current Week = var thisday = TODAY()
    return thisday - WEEKDAY(thisday) +1 & " - " & thisday
     
    Previous Week = var thisday = TODAY()
    return thisday - WEEKDAY(thisday) -6 & " - " & thisday-WEEKDAY(thisday)
     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

  • Anonymous's avatar
    Anonymous
    6 years ago

    mahoneypat 

     

     

    Thanks for your response but your solution is not clear. I'm not sure what I'm suppose to be looking a but this is what I'm seeing below. Please clarify.

     

     
    Current Week = var thisday = TODAY()
    return thisday - WEEKDAY(thisday) +1 & " - " & thisday
     
    Previous Week = var thisday = TODAY()
    return thisday - WEEKDAY(thisday) -6 & " - " & thisday-WEEKDAY(thisday)
     

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Yes.  Here is what it will show on the next few days

Sat - 8/15/2020-8/15/2020

Sun - 8/16/2020-8/16/2020

Mon - 8/16/2020-8/17/2020

 

If that is not correct you can adapt the approach.  If need more help, just reply and @ me.

 

Regards,

Pat

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

mahoneypat 

 

 

Thanks for the clarification. On Saturday i want it to show Sat - 8/09/2020-8/15/2020 (start and end of the current week) instead not Sat - 8/15/2020-8/15/2020 since that marks the end of the current week, then it stops counting for that week.