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.
Hi guys,
Been working on a report that Shows Change of Progress of different projects from start of last week to end of last week (Monday - Sunday)
Progress is shown as a %
Now im trying to implement a way for a Slicer to filter the dates of my visual so i can see the Change over different periods.
If i select 01/01/2021 - 25/03/2021 (Today), then it should take the Progress from the Start Date (01/01/2021) and the End Date (25/03/2021) and will show my difference.
Currently, the way i have been doing this is i have made a seperate Calendar Table that shows Dates of Last Week:
Calendar = calendar(today() - weekday(today(),2)+1,today() + 7 - 1* WEEKDAY(TODAY(),2))
Last Week = 'Calendar'[Date] - 7
I then get the Progress from Start and End Date:
Progres at Start = LOOKUPVALUE(ProjectProgress[ProgressPercentage],ProjectProgress[ProjectNumber], Projects[ProjectNumber], ProjectProgress[ProgressDate], MIN('Calendar'[Last Week]))
Progres at End = LOOKUPVALUE(ProjectProgress[ProgressPercentage],ProjectProgress[ProjectNumber], Projects[ProjectNumber], ProjectProgress[ProgressDate], MAX('Calendar'[Last Week]))
(Same Formulas just MIN for Start Date and MAX for End Date)
Then i subtract End by Start to get my Change Column figures.
Is there a way to get the slicer to change what dates the Start and End dates will be then show me the difference?
I understand my current way is not the way i will use for this new way.
Solved! Go to Solution.
@paulfink , refer if my WOW blog can help
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
@paulfink , refer if my WOW blog can help
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
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 |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |