Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I need to calculate a maximum sales value of a calculation, which varies per month, but the max only accepts field as a parameter. Ex Max (sales) (take the Month with higher value)
Solved! Go to Solution.
Have you tried using a New Column rather than a new Measure?
Hi @Jacy,
If you want get multiple result from one measure, you should add group column to let it calculated through multiple records.
Sample:
Ex MAX = MAX('CALENDAR'[Rolling])
Regards,
Xiaoxin Sheng
Have you tried using a New Column rather than a new Measure?
Unfortunately it would not work, the calculation is variant, I can not plaster, sales is just an example, the actual calculation is turnover.
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |