Forum Discussion

syldia's avatar
syldia
Regular Visitor
6 years ago
Solved

Return Value from Another Column

ORIGINAL POST   Hi There,   I have a table of my customers and their purchase activities broken down by date (Customer ID, Date, Order ID, Source).   I would like to create a measure that can r...
Need Help
  • az38's avatar
    az38
    6 years ago

    syldia 

    try

    First Session Source =
var FirstPurchaseDate = calculate(MIN('Users'[sl_timeStamp]),ALLEXCEPT('Users','Users'[User]))
return calculate(FIRSTNONBLANK('Users'[source],1),FILTER(ALL('Users'),'Users'[User]=SELECTEDVALUE('Users'[User]) && 'Users'[sl_timeStamp]=FirstPurchaseDate))

    do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Community Champion
6 years ago

syldia 

replace ";" to "," comma. it's a system localization question

do not hesitate to give a kudo to useful posts and mark solutions as solution

syldia's avatar
syldia
Regular Visitor
6 years ago

Formula is working now. However as you can see from visual below it is not delivering the correct results. 

 

  • az38's avatar
    az38
    Community Champion
    6 years ago

    syldia 

    try

    First Session Source =
var FirstPurchaseDate = calculate(MIN('Users'[sl_timeStamp]),ALLEXCEPT('Users','Users'[User]))
return calculate(FIRSTNONBLANK('Users'[source],1),FILTER(ALL('Users'),'Users'[User]=SELECTEDVALUE('Users'[User]) && 'Users'[sl_timeStamp]=FirstPurchaseDate))

    do not hesitate to give a kudo to useful posts and mark solutions as solution