Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
From below screenshot how do i get col_orderstatus of max col_orderid number for same col_tnumber
Thanks,
Prathy
Solved! Go to Solution.
Hi @pmadam ,
Please try the below measure, it works on my desktop:
CALCULATE(MAX('Table (5)'[Status]),FILTER('Table (5)','Table (5)'[Orderid] = CALCULATE(MAX('Table (5)'[Orderid]),ALLEXCEPT('Table (5)','Table (5)'[Number]))))
Aiolos Zhao
Proud to be a Super User!
Hi @pmadam ,
Please try the below measure, it works on my desktop:
CALCULATE(MAX('Table (5)'[Status]),FILTER('Table (5)','Table (5)'[Orderid] = CALCULATE(MAX('Table (5)'[Orderid]),ALLEXCEPT('Table (5)','Table (5)'[Number]))))
Aiolos Zhao
Proud to be a Super User!
Hi,
Try these measure
max_orderid = calculate(max(data[col_orderid]),allexcept(data,data[col_orderstatus]))
order_status of max order id = if(hasonevalue(data[col_tnumber]),lookupvalue(data[col_orderstatus],data[col_tnumber],values(data[col_tnumber]),data[col_orderid],[max_orderid]),blank())
Drag the second measure to your visual.
Hope this helps.
User | Count |
---|---|
83 | |
70 | |
69 | |
66 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |