Add different totals after Date columns

[ton-v]

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

[v-chuncz-msft]

@ton-v ,

Currently, there is no elegant way. You may try ISINSCOPE to add measures.

[ton-v]

i will test this but it seems really complicated