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.
Hello community,
I need a formula for a calulated column that shows me the highest value in column X if the values in column Y are the same.
Example: Several orders are posted on one date for a costumer, but I only want to look at the latest (highest transaction number) entry.
Thanks for your help,
Marco
Solved! Go to Solution.
Try something like this (adjust for your actual table & columns names)
Last transaction = CALCULATE(MAX([Transaction no]),ALLEXCEPT('Transactions', 'Transactions'[Customer ID], 'Transactions'[Transaction date]))
Try something like this (adjust for your actual table & columns names)
Last transaction = CALCULATE(MAX([Transaction no]),ALLEXCEPT('Transactions', 'Transactions'[Customer ID], 'Transactions'[Transaction date]))
ADD: I need a formula for a calulated column that shows me the highest value in column X if the values in column Y AND Z are the same.
Example: Several orders are posted on one date for a costumer, but I only want to look at the latest (highest transaction number) entry. Transaction number = X, Date = Y, Costumer ID = Z.
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
119 | |
41 | |
40 | |
28 | |
22 |