Forum Discussion

jobf's avatar
jobf
Helper II
2 years ago
Solved

LOOKUPVALUE with multiple conditions

Hello. I need to create a column that takes values ​​from a column based on more than one condition. Example: Variety Period Bags P1 M 120 P2 M 159 P3 M 101 P4 P 90 P5 P...
Need Help
  • uzuntasgokberk's avatar
    uzuntasgokberk
    2 years ago

    Hello jobf,

     

    You can use below DAX formula.

    "

    pbısupportgokberkuzuntas =
    Var maxval_=
    CALCULATE(
    MAX(Tablesil1[Bags]),
    ALLEXCEPT(Tablesil1,
    Tablesil1[Periods]
    )
    )
    RETURN
    LOOKUPVALUE(Tablesil1[Variety],Tablesil1[Bags],maxval_)
    "

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |

  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    jobf 

    you can try this

     

    Column =
    maxx(FILTER('Table','Table'[Period]=EARLIER('Table'[Period])&&'Table'[Bags]=maxx(FILTER('Table','Table'[Period]=EARLIER('Table'[Period])),'Table'[Bags])),'Table'[Variety])
     
     
uzuntasgokberk's avatar
uzuntasgokberk
Super User
2 years ago

Hello jobf,

 

You can use below DAX formula.

"

pbısupportgokberkuzuntas =
Var maxval_=
CALCULATE(
MAX(Tablesil1[Bags]),
ALLEXCEPT(Tablesil1,
Tablesil1[Periods]
)
)
RETURN
LOOKUPVALUE(Tablesil1[Variety],Tablesil1[Bags],maxval_)
"

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |