Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys,
I'm trying to retrieve a value from another column using the DAX function LOOKUPVALUE(), but I'm getting a very annoying error: A table of multiple values was supplied where a single value was expected.
I'm trying to execute the following DAX formula:
next trans name = VAR visord = [order_within_visitor] VAR visid = [visitor_id] RETURN if(visord = MAXX(FILTER('public pageview', [visitor_id] = visid), 'public pageview'[order_within_visitor]),
"Exit",
LOOKUPVALUE([page_transname], 'public pageview'[order_within_visitor], (visord+1), 'public pageview'[visitor_id], visid ))
I want to retrieve the next value of a series and put it in the "next trans name" field. I need to check if it is the last value of the series, because it should have a different behaviour when it is. If it's not the last number in the series, it should lookup the page_transname for that record and put it in the "next trans name" field.
I have something like the following datastructure (very much simplified):
visitor_id | order_within_visitor | page_transname |
0 | 1 | Home |
0 | 2 | About |
0 | 3 | Search |
1 | 1 | Home |
1 | 2 | Detail |
Does someone know what the problem might be?
Thanks!
Solved! Go to Solution.
Tackled the problem! Happens to be that there are 2 duplicate values in my dataset of 100,000 records... Didn't see that!
Tackled the problem! Happens to be that there are 2 duplicate values in my dataset of 100,000 records... Didn't see that!
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
56 |
User | Count |
---|---|
99 | |
92 | |
84 | |
74 | |
66 |