Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

BEST SALES MONTH

Busco makes a measurement that shows me the amount of the best billing month to make a comparison with the current month. That is, if the best month was January 2022 with a turnover of 2,581,000.00, ...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi CSandoval0 ,

You can create two measures to show the max amount and the best month:

MaxAmount = Max('YourTable'[amount])
MaxDate = 
CALCULATE(
    MAX('YourTable'[date]),
    Filter(
    'YourTable',
    'YourTable'[amount] = [MaxMount]
    )
)


Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.