The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I'm having the following problem. I have a couple of sales tables relating to a date table as well as a persons table.
Now, i'm adding a table to define the teams for each person. The problem i have is that people have been in different teams and can switch in the future, but everyone is doing the same activities. I have the startdate and enddate for each person for when they where in the same team. I need a date filter for the results of each team on an individual level, team level and department level (all teams).
In an ideal world i would like it to connect to my date table, but i haven't been able to work that out.
Example: Person x is working in a team A from the 1st of Januari - 1st of Februari. Then switches to team B from the 1st of Februari - 1st of March. When i set a date filter from the 1st of Janari - 1st of March and select team A. I only need the results of person X from the 1st of Januari - 1st of Februari.
Any suggestions?
Solved! Go to Solution.
User | Count |
---|---|
77 | |
75 | |
36 | |
31 | |
28 |
User | Count |
---|---|
106 | |
98 | |
55 | |
49 | |
48 |