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 have this list of quotations, where each quotation has a version, from A and up.
I want to add custom column, that contain the highest version, for each quotation.
Many thanks in advance,
Solved! Go to Solution.
Hi @RafaelAri ,
You could try below code:-
Column =
CALCULATE (
MAX ( 'Table'[version] ),
FILTER ( 'Table', 'Table'[Quote no] = EARLIER ( 'Table'[Quote no] ) )
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hey Try using this
Create a new column under the modeling tab and try this:
Max Value = Calculate (max('Max Value'[Version]), allexcept('Max Value','Max Value'[Quot. No.]))
Where [Max Value] is the table name
Hi @RafaelAri ,
You could try below code:-
Column =
CALCULATE (
MAX ( 'Table'[version] ),
FILTER ( 'Table', 'Table'[Quote no] = EARLIER ( 'Table'[Quote no] ) )
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Sorry, doesn't work.
EARLIER function is not correct.
Where should I use this code? in Mesures table or in the Query-Editor?
My appologies..., it works!
Thanks Samarth
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |