Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
74 | |
64 | |
49 | |
36 |
User | Count |
---|---|
115 | |
86 | |
80 | |
58 | |
39 |