Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good Afternoon :
I have created a measure called % Agt talk time and I need to show the last week result of this measure .
To achieve this i ve created a week ranking , so I need to filter upon selecting a FIXweek (i.e week 3 ) the results for the week rank 53 .
I can´t use last week due to the change of year and sepciall weekly requests , so the ranking made sense for me, however the measure is not working. Any help to achieve this ? The results will be filteres by year - Week
Used Measure :
Will build a new date table and work from there , will let you know if that works
@LuisApollo , Make sure you have a separate date or week year table and in visual you use week year from that table only
try measures like
This Week = CALCULATE([% Agt Talk time], FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE([% Agt Talk time], FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))
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
Well, built a time table and made the Measure , it does help since i can see the last fomr selected , however it doesn´t populate a table and only works if one value is selected
Very close but still missing something
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
45 | |
44 | |
28 | |
22 |