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.
Hi everyone,
I have two tables of data - one is a call log where I have a user, a bunch of metrics and a timestamp for when the call starts.
I have a second table of actions taken by the user while on the call. User ID, Action and time of action. Each call should have mutliple actions associtated with it.
I want to click on a call and drill through (even filter would be fine at this point) to the list of actions performed during this call.
When I try to apply a greater than or equal to filter for the timestamp I get no results.
Any help is greatly appreciated.
There is not a call ID in both tables (see attached sample tables).
In both tables we have date/time and user ID, those would be the common keys.
I want to click on a calland see all a list of the actions that correspond with that call. User ID would be one key, and the data time as another.
Sorry I am unable to attach the PBIX file here
Call_ID | Start Time | User | End Time |
1 | 2024-01-01 0:12 | a1 | 2024-01-01 0:16 |
2 | 2024-01-01 2:32 | a1 | 2024-01-01 2:33 |
3 | 2024-01-01 2:22 | v1 | 2024-01-01 2:33 |
action | user | datetime |
a | a1 | 2024-01-01 0:12 |
b | a1 | 2024-01-01 0:14 |
c | a1 | 2024-01-01 0:16 |
d | a1 | 2024-01-01 2:32 |
e | a1 | 2024-01-01 2:33 |
q | v1 | 2024-01-01 2:22 |
w | v1 | 2024-01-01 2:32 |
e | v1 | 2024-01-01 2:32 |
r | v1 | 2024-01-01 2:33 |
OUtput - Call | OUtput - User | Output - Action |
1 | a1 | a |
1 | a1 | b |
1 | a1 | c |
@AjansPF , Is there a column call ID, relating these two tables? Common dimension?
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
61 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |