Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have this DAX formula that works fine but I was wondering if it can be adjusted so it includes a second table. My model had table # 1 (historical data) and table #2 (current date). Each of these tables has exactly the same structures and I am trying to create a virtual table that would count the number of callers and display the caller name beside the count. My formula works fine if I am considering only table #1 but is there a way to include table #2 into this?
Callers Summary =
SUMMARIZECOLUMNS (
'Table #1' [Caller_Name],
"Caller Counts", [CALLER_COUNT]
)
Solved! Go to Solution.
i was able to do this which worked for me
Combined Callers Summary =
UNION(
SUMMARIZECOLUMNS (
'Table #1' [Caller_Name],
"Caller Counts", [CALLER_COUNT]
),
SUMMARIZECOLUMNS (
'Table #2' [Caller_Name],
"Caller Counts", [CALLER_COUNT]
)
)
i was able to do this which worked for me
Combined Callers Summary =
UNION(
SUMMARIZECOLUMNS (
'Table #1' [Caller_Name],
"Caller Counts", [CALLER_COUNT]
),
SUMMARIZECOLUMNS (
'Table #2' [Caller_Name],
"Caller Counts", [CALLER_COUNT]
)
)
User | Count |
---|---|
84 | |
76 | |
74 | |
49 | |
39 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |