Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
You've made three or four posts which are asking fairly similar time-based questions, could you not have combined these into one post explaining more clearly what you're trying to do?
Hi @Anonymous,
Do you want to show the data last 2 weeks or calculate the data last 2 weeks?
If you want to calculate the data last 2 weeks, you could use Today()-14.
Measure = CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),'Table'[Date]=TODAY()-14))
If you want to show the data last 2 weeks, you could try with relative date slicer. When you open your report next day, it will show the data from 7/18/2018-7/31/2018.
If you still need help, please share some your data sample which could reproduce your scenario and your expected output.
Best Regards,
Cherry
Hi
Thanks to reply
Requirement is , last 2 weeks an employee worked given tasks . So we need to find the completed tasks from last 2 weeks
Hi @Anonymous,
Please have a reference of this similar thread.
Best Regards,
Cherry
If we check every day like tomorrow once and day after tomorrow once , date should change from current date to previous 14 days(2weeks)
This is what you are looking for:
TODAY () -14
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |