The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |