Return the Highest value from a row to a new table's collumn

[JPQ]

Hi,

I'm having a problem relating some values that are caused by the type of table (i think!)

In one table i have the cumulative expenses by month and by the type of investment. In another table i have the maximum cost that i can spend in that year by type of investment.

So, in other to compare the max of the month (cumulative), the max of the year and the atual spent by type of investement, i think i need to tranform a row From Table A to a collumn in Table B.

I would like to have a graph like the above... I bet it´s something simple or strutural, but i´m kind of new to DAX...

thanks

[v-chuncz-msft]

@JPQ,

You may try LOOKUPVALUE Function, TOPN Function and MAXX Function.

[PattemManohar]

@JPQ Please try to create as a measure to get the maximum value dynamically.