Power Query - Matching value

[Anonymous]

Hi Team,

Power Query syntax :

I need following result for ID 5 only, please help  me.

Thanks,

KV's

[V-pazhen-msft]

@Anonymous 
I would recommend you create this column using dax instead power query, which is much simpler.

Weight = IF('Table'[ID]=5, CALCULATE(SUM([Value]),ALLEXCEPT('Table','Table'[Markets]),'Table'[ID]=39))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Why should the answer be 4?  Why not 0.65 or 0.35?  Bother to explain in detail.

[Anonymous]

Hi @Ashish_Mathur ,

ID 5 pick ID 39 value for Weight and it must be match Markets.

thanks,

kV's

[Ashish_Mathur]

Hi,

Try this calculated column formula

Weight = calculate(max(data[value]),filter(data,data[markets]=earlier(data[markets])&&data[id]=39))

Hope this helps.