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
    )
)

     

     

     

     

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, 

According to your description and sample data, I can roughly understand your requirement, it seems that you want to get the most recent balance value based on your newly added index column, right? I think you can try this measure:

This is the test data I created based on your description:

Measure =

var _minindex=MINX(ALL('Table'),'Table'[Index])

return

CALCULATE(SUM('Table'[Balance]),FILTER(ALL('Table'),'Table'[Index]=_minindex))

 

And you can palce a measure into the card chart to get what you want, like this:

 

You can download my test pbix file below

 

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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

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

This worked as well. Thank you!