Forum Discussion

Creative_tree88's avatar
Creative_tree88
Helper V
4 years ago
Solved

Current Week Value based on date field

Hi - I am hoping you can help!  I suspect this is pretty simple but it's really late, I am a little stressed out as I need to get this sorted by tomorrow...really hope you guys can come to the rescue...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Creative_tree88 

    Try to create measures as following:

     

    Result:

    Please refer to the attachment below for details.

    Note: Only results older than 14 days are included in the attachment, you can switch measures to get results younger than 7 days.

     

    Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, Creative_tree88 

Try to create measures as following:

 

Result:

Please refer to the attachment below for details.

Note: Only results older than 14 days are included in the attachment, you can switch measures to get results younger than 7 days.

 

Hope this helps.

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Creative_tree88's avatar
    Creative_tree88
    Helper V
    4 years ago

    v-angzheng-msft  - many thanks for your help with this.  I'll study the attachment and your suggested technique and hopefully it'll work exactly as planned!  Best regards