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 

Aceess Denied.

It makes it easier to give you a solution.

  1. Sample (dummy dataset) data as text, use the table tool in the editing bar
  2. Expected output from sample data
  3. Explanation in words of how to get from 1. to 2.

Could you please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented? 


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.