Forum Discussion
Maximum annual billing
Good
How could you insert a measure that filters each year with your maximum billing?
I want to use it to insert 3 cards with a maximum turnover of 3 years.
My billing measure is called "Total Billing"
Thank you!!
4 Replies
- amitchandak
Super User
Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos. - Fowmy
Anonymous
Not sure about your model and the table structure, Let's say you have an orders table with the amount, if you want to get the maximum order value for a certain year, follow this example:2020 Max Order= CALCULATE( MAXX( SUMMARIZE( Orders, Orders[OrderNo]), Orders[Amount] ), Dates[Year] = 2020 )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Good morning
I attach my model so you can be easier with your answer.
What I'm trying to do is know what's the biggest bill of that year.
As another question, could you specify the customer to which that invoice belongs? https://gyazo.com/b44228424a0cca399eeab8e45a7ebcbc
https://gyazo.com/0c69a2f7ed43ffc957e9f48824f164cf
- v-easonf-msft
Community Support
Hi, Anonymous
Can you provide specific table data (preferably in English) and expected result for testing?
You can check if solution in this thread can help you.
https://community.powerbi.com/t5/Desktop/Return-Sales-of-Max-Value-Year/m-p/1365541
Best Regards,
Community Support Team _ Eason
