LOOKUPVALUE with multiple conditions

[jobf]

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	95

I needed to create a column that showed the variety whose bags were larger in a given period. It would look something like this:

Variety	Period	Bags	V + P
P1	M	120	P2
P2	M	159	P2
P3	M	101	P2
P4	P	90	P5
P5	P	95	P5

[uzuntasgokberk · Accepted solution]

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 |

[Ashish_Mathur]

Hi,

Write this calculated column formula

Column = LOOKUPVALUE(Data[Variety],Data[Bags],CALCULATE(MAX(Data[Bags]),FILTER(Data,Data[Period]=EARLIER(Data[Period]))),Data[Period],Data[Period])

Hope this helps.

[ryan_mayu · Accepted solution]

@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 · Accepted solution]

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 |