Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I can usually scour the Google machine to find answers, but this one has me stumped... I'm not sure what to try next?
I need to filter the highest REVISIONNUM to each POLINENUM for all PONUM.
I'm trying to calculate total cost over a period of time and am getting duplicate SK_NS_MARKUPTOTAL additions, which makes the total costing much higher than reality.
I have tried the formula below with no success and both columns are Data Type: Whole Number
Table = POLINE
I only want the totals for REVISIONNUM "2" to be calculated in the above table.
Thanks for your help.
Solved! Go to Solution.
I think you are not closing max at the correct place. You need to have ), before allexpect.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
I think you are not closing max at the correct place. You need to have ), before allexpect.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |