Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Muy buenas tardes, intentaré explicar lo mejor posible mi problema. Tengo cinco bolsas presupuestarias, es decir, cinco bolsas de dinero del que cuelgan ciertos proyectos. El caso es que cada proyecto no tiene su presupuesto fijo dentro de esta bolsa presupuestaria sino que entre todos pueden gastar el total.
Pongo ejemplo:
idProyecto | Presupuesto |
PRY00001 | 70.000,00 |
PRY00002 | 100.000,00 |
PRY00003 | 100.000,00 |
PRY00004 | 40.000,00 |
PRY00005 | 85.000,00 |
PRY00006 | 314.200,00 |
PRY00007 | 25.000,00 |
PRY00008-1 | 314.200,00 |
PRY00008-2 | 314.200,00 |
PRY00009 | 314.200,00 |
PRY00004-1 | 10.000,00 |
PRY00008-3 | 314.200,00 |
PRY00010 | 314.200,00 |
PRY00011 | 314.200,00 |
PRY00012 | 314.200,00 |
Como podeis ver, hay proyectos que comparten el mismo presupuesto. Mi problema es que no se como relacionar a cada presupuesto los proyectos que le corresponden de manera que pueda ver cuanto queda disponible en cada uno de ellos.
Solved! Go to Solution.
Hello @94veiga ,
Do you want to calculate how many positions are in each budget?
If so, you can create a table visual like this,
If you don't meet your requirements, could you show the exact expected result based on the table you shared?
Best regards
Community support team _ zhenbw
If this post helps,then consider Accepting it as the solution to help other members find it faster.
Hi @94veiga ,
How about the result after you follow the suggestions mentioned in my original post?
Could you please provide more details or expected result about it If it doesn't meet your requirement?
If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @94veiga ,
Do you want to calculate how many positions are in each budget?
If so, you can create a table visual like this,
If you don't meet your requirements, could you show the exact expected result based on the table you shared?
Best regards
Community support team _ zhenbw
If this post helps,then consider Accepting it as the solution to help other members find it faster.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |