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.
So I want to show all the People and the activity logged against them where their date available is -7 days, -14 days etc. and visualise in a graph/table.
I have a Candidates table (with date available) joined to Candidates Activity on a unique ref with a Dates table joined on the Candidates availability date. The date of the activities is also joined to the Dates table.
Thanks gang
Tried this but can't get it to work
Table = CALCULATETABLE('CandidateActivity',FILTER('Candidates','Candidates'[date_available],DATESBETWEEN('Candidates'[date_available],DAY(-7),now())))
This is the table outcome I am after. I'm alittle worried this isn't doable? However you guys always seem to pull something out the bag.
Candidate | Status | Date Available | Week -4 | Total activity in week | Week -3 | Total activity in week | Week -2 | Total activity in week | Week -1 | Total activity in week | Week 0 | Total activity in week | Week +1 | Total Activity |
Bob Smith | New Arrival | 9th June 2017 | Calls | 2 | Calls | 0 | Email Sent | 3 | Interview | 1 | Email Sent | 3 | 9 | |
Meeting | 1 | Meeting | 0 | Calls | 1 | Calls | 5 | Calls | 1 | 8 | ||||
CV Send out | 5 | CV Send out | 3 | CV Send out | 0 | CV Send out | 1 | CV Send out | 0 | 9 | ||||
Greg Jones | Actively Seeking | 7th Jul 2017 | Calls | 2 | ||||||||||
Meeting | 1 | |||||||||||||
CV Send out | 5 |
@Anonymous,
You needn't to create another to filter the date. Just create a measure in your original table, and you can get your expected table. The steps below is for you reference.
Regards,
Charlie Liao
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 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |