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.
have a doubt that I still can not solve by watching your classes.
How do you set up a type of cash flow in PBI?
Example:
Tables: Calendar, Initial and Monthly Balance of the Bank Account, Daily Financial Movement
Day 1 day 2 day 3 ..... day 31
Opening Balance 100.00 120.00 60.00
Category of Expenses and revenues. -40,00 +20,00 - 90,00
Category of Expenses and revenues. +60.00 -80.00 +20.00
Closing balance 120.00 60.00 -10.00
att.
Is what you are presenting the result that you want or the data that you are working with?
In the Zip file = pbix e data source (xlsx)
How to calculate the final balance on 01/01/2017?
How to calculate the opening balance on 02/01/2017, what is the final balance on 01/01/2017?
result I want
OK, then can you provide an example of your starting data?
Any news about this subject?
https://app.powerbi.com/groups/me/dashboards/56211df1-2943-4c78-a937-041570b9a0a3
<iframe width="933" height="700" src="https://app.powerbi.com/view?r=eyJrIjoiZDljMTlhMWYtYWQ5Yy00ODU1LWE1OTQtYjdjNmY4MjA2MTFhIiwidCI6IjMyMzlmYzZkLTdlZTUtNDU5Zi04N2UxLTkzMWJhMGVkYWEwNCIsImMiOjR9" frameborder="0" allowFullScreen="true"></iframe>
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |