Power Query syntax :
I need following result for ID 5 only, please help me.
@Udt_KV I would recommend you create this column using dax instead power query, which is much simpler.
Why should the answer be 4? Why not 0.65 or 0.35? Bother to explain in detail.
Hi @Ashish_Mathur ,
ID 5 pick ID 39 value for Weight and it must be match Markets.thanks,
Try this calculated column formula
Weight = calculate(max(data[value]),filter(data,data[markets]=earlier(data[markets])&&data[id]=39))
Hope this helps.
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.