Combining LOOKUPVALUES

Anonymous — Fri, 15 Sep 2023 17:48:47 GMT

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

)

Re: Combining LOOKUPVALUES

Mahesh0016 — Sat, 16 Sep 2023 06:00:05 GMT

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

topic Re: Combining LOOKUPVALUES in DAX Commands and Tips

Combining LOOKUPVALUES

Re: Combining LOOKUPVALUES