Forum Discussion

jwin2424's avatar
jwin2424
Icon for Resolver I rankResolver I
4 years ago
Solved

Grab data from most recent row available

Hello,    I am trying to create a Card visual to show the current balance of my account. In the example below, I would lilke to have the card display the balance from the most recent row in the dat...
  • smpa01's avatar
    smpa01
    4 years ago

    jwin2424  please use the following

     

    _Balance = 
CALCULATE (
    MAX ( 'Table'[Balance] ),
    FILTER (
        'Table',
        VAR _mxIndex =
            CALCULATE ( MIN ( 'Table'[Index] ), ALL ( 'Table' ) )
        RETURN
            'Table'[Index] = _mxIndex
    )
)

     

     

     

     

jwin2424's avatar
jwin2424
Icon for Resolver I rankResolver I
4 years ago




 ABCDE
 Posting DateDescriptionAmountBalanceIndex
112/5/2021Groceries-53.62674.451
212/5/2021Gas-42.81728.072
312/5/2021Rent-1800770.883
412/5/2021Utilities-213.122570.884


You'll have to forgive me, as I am still learning how to use Power BI. My table has the index column (created  in edit query) and then I went to my visualization section and created a card. I made a measure (by selecting the table I wanted it for in the fields area and then selecting "add measure). I entered in the formula, and it looks like I got a massive balance in return. 

The dats is pulled in decending order, so the most recent transaction is at the very top. I simple want the card to say "674.45." 

Thank you for helping!

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

jwin2424  please use the following

 

_Balance = 
CALCULATE (
    MAX ( 'Table'[Balance] ),
    FILTER (
        'Table',
        VAR _mxIndex =
            CALCULATE ( MIN ( 'Table'[Index] ), ALL ( 'Table' ) )
        RETURN
            'Table'[Index] = _mxIndex
    )
)