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)
     

     

Anonymous's avatar
Anonymous
Not applicable
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

You would use these two measures each in their own Card visual, to show in text the week to date and previous week ranges.  I thought that was what you were looking for.  If not, please clarify.

 

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
    Not applicable
    6 years ago

    mahoneypat 

    Awesome! This is exactly what i want because the Week to date gives the start of the week and current date. Quick question though would this week stop counting on Sat (08/15/2020) since that marks the end of the current week? If yes, then it's perfect and this is exactly waht I want.

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