Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@JPQ,
You may try LOOKUPVALUE Function, TOPN Function and MAXX Function.
Proud to be a PBI Community Champion