Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
Power Query syntax :
I need following result for ID 5 only, please help me.
Thanks,
KV's
@Anonymous
I would recommend you create this column using dax instead power query, which is much simpler.
Hi,
Why should the answer be 4? Why not 0.65 or 0.35? Bother to explain in detail.
Hi,
Try this calculated column formula
Weight = calculate(max(data[value]),filter(data,data[markets]=earlier(data[markets])&&data[id]=39))
Hope this helps.