Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hey all,
Im trying to make a new column with the max value of another column by supplier and year.
Supplier | Year | Amount | Max |
A | 2022 | 5000 | 7000 |
A | 2022 | 2000 | 7000 |
A | 2022 | 7000 | 7000 |
A | 2023 | 4000 | 4000 |
A | 2023 | 2000 | 4000 |
B | 2022 | 5000 | 6000 |
B | 2022 | 6000 | 6000 |
B | 2022 | 2000 | 6000 |
B | 2023 | 1500 | 1500 |
Hope this makes sense, let me know if you need anymore information.
Any help would be very much appreciated.
Thanks
Nathan
Solved! Go to Solution.
@Nathan__Mox , A new column in DAX
max= maxx(filter(Table, [Supplier] = earlier( [Supplier]) && [Year] = earlier( [Year]) ), [Amount])
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
Hi, @Nathan__Mox
You can try the following methods.
Column = CALCULATE(MAX('Table'[Amount]),ALLEXCEPT('Table','Table'[Supplier],'Table'[Year]))
Or
Column 2 = CALCULATE(MAX('Table'[Amount]),FILTER('Table',[Supplier]=EARLIER('Table'[Supplier])&&[Year]=EARLIER('Table'[Year])))
Measure:
Measure = CALCULATE(MAX('Table'[Amount]),ALLEXCEPT('Table','Table'[Supplier],'Table'[Year]))
Or
Measure 2 = CALCULATE(MAX('Table'[Amount]),FILTER('Table',[Supplier]=SELECTEDVALUE('Table'[Supplier])&&[Year]=SELECTEDVALUE('Table'[Year])))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Nathan__Mox , A new column in DAX
max= maxx(filter(Table, [Supplier] = earlier( [Supplier]) && [Year] = earlier( [Year]) ), [Amount])
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
99 | |
69 | |
46 | |
39 | |
33 |
User | Count |
---|---|
163 | |
110 | |
61 | |
51 | |
40 |