Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello
I want to have in my column "max sales" the maximum of the values displayed in my table.
Here in the example below I would like to show in the column "max sales" : 1 195 256 in all the lines.
Do you how I can do that in a DAX formula?
thank you
Solved! Go to Solution.
@claxxx , Assume sales is a measure and you are using month year column in row
calculate( maxx(values(Table[Year Month]),[sales]), allselected() )
Thank you a lot! It works 🙂
@claxxx , Assume sales is a measure and you are using month year column in row
calculate( maxx(values(Table[Year Month]),[sales]), allselected() )
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.