Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |