Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |