Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Get Maximum Budgets with Conditionals

Greetings, I am having difficulty getting the budgeted maximum budgets due to the following conditions. 1. the paceinte 8 has 3 treatments two already started therefore I must porder filter th...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Syndicate_Admin In general MAXX(FILTER(...), ...) or MAXX(SUMMARIZE(FILTER(...), ...), ...) Hard to be more specific without mocking it up. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    Current status

    Expected

    I need to be able to filter the budgets to which payments were made and if no payment is made show me the largest budget for that patient.