Forum Discussion
Anonymous
2 years agoNot applicable
Combining LOOKUPVALUES
I have two sheets Go LMS Signups and Flex LMS Signups and they both have a column called Requested Signups. I need to get the Requested Signup information from each of those sheets into a 3rd sheet as a column. The reference string for all three sheets is the email column. I was able to add two columns to the 3rd sheet, pulling that information individually from each sheet, but I want one column instead of two. How can I turn these two formulas that get me two columns, into one formula that combines this information?
Flex Requested Signup Origin =
CALCULATE(
FIRSTNONBLANK('Flex LMS Sign Up Requests (2)'[Requested Signup], 1),
FILTER(all( 'Flex LMS Sign Up Requests (2)'), 'Flex LMS Sign Up Requests (2)'[User Email] = 'LMS User Analysis'[Email])
)
Go Requested Signup Origin =
CALCULATE(
FIRSTNONBLANK('Go LMS Sign Up Requests (2)'[Requested Signup], 1),
FILTER(all( 'Go LMS Sign Up Requests (2)'), 'Go LMS Sign Up Requests (2)'[User Email] = 'LMS User Analysis'[Email])
)
1 Reply
- Mahesh0016Super User
Anonymous I hope this helps you
Create a calculated Column following below :C =IF ( ISBLANK ( 'Table'[Flex Requested Signup Origin] ), 'Table'[Go Requested Signup Origin], 'Table'[Flex Requested Signup Origin] )