Forum Discussion

ton-v's avatar
ton-v
Frequent Visitor
7 years ago

Add different totals after Date columns

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 :

 

https://ibb.co/6ZqsHJw

 

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.

 

https://ibb.co/cCfsD15

 

Thank you in advance for the help

 

2 Replies