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.
Hello,
My end goal is to make an automated reporting procedure, where I will copy/paste every month a new excel file (trial balance of each month) on a folder and then the outcome will appear on a Power BI dashboard in a matrix format where each column is a month and other columns are Q1,Q2,6-month, etc. Each row represents balance sheet's account numbers. The original files have >100k rows/accounts and the date is in a format D/M/YYYY.
My problem is that the trial balance has cummulative numbers, so I have to substract each column to have the outcome for a specific month i.e. Mar - Feb = Change in March. Any idea on how can I tackle this problem?
Unfortunatelly, I cannot share my original data so I created the power query table and the reporting matrix on the dashboard with dummy numbers.
Thanks in advance!
Cheers,
Alex
Solved! Go to Solution.
It looks like you are trying to create a calculated measure. You need to do this as a COLUMN.
See attached pbix file below signature for reference on what I have done.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |