Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • 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] )