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,
i am new to Power BI and would need your help.
I am trying to replicate an Excel file where is used PowerPivot and Excel formulas to power bi.
The Exel file has as an objectif to calculate the turnover per day, then to give the total of the week, calculate the total of budget for the week. Same for MTD and YTD.
on Excel i got everything working as you can see on this image :
Now i want to replicate this on Excel, because the file is getting heavy.
Its very easy to add the shopping center, then the date column and then the turnover per day and filter it per week.
My problem is that i want to add total of the budget, MTD Turnover and budget and finally YTD turnover and budget and this after the date column.
Thank you in advance for the help
i will test this but it seems really complicated
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 |