Forum Discussion
weekly report
Hello everybody.
I imported two databases into Power BI, one relating to the quantities transported during the year 2022 and one relating to the quantities foreseen in the budget. Every week I have to submit a report where in the same matrix or table I show the tons transported in the last three weeks in the first three lines, while in the fourth line I have to show the cumulative from the beginning of the year (therefore also including the last three weeks reported above). This obviously both for the budget and for the final balance. I accept suggestions that allow me to show in the same visual object (matrix / table) the tons transported for these four periods. Below I leave an example, but without the fourth line (which I can not show).
Hi Santi01, try this:
- Create this calculate column: (Assuming you have a date column)
- Create another calculate column:
Week = if(WEEKNUM(Tabla[Date])=WEEKNUM(today()), CONCATENATE("Week ",Tabla[Week Start Day]),if(WEEKNUM(Tabla[Date])=WEEKNUM(today())-1, CONCATENATE("Week ",Tabla[Week Start Day]),if(WEEKNUM(Tabla[Date])=WEEKNUM(today())-2, CONCATENATE("Week ",Tabla[Week Start Day]), "Rest of the year")))- Your table is something like this:- The result is a table like this:
I hope this works it for you,
Best regards
2 Replies
- Bifinity_75Solution Sage
Hi Santi01, try this:
- Create this calculate column: (Assuming you have a date column)
- Create another calculate column:
Week = if(WEEKNUM(Tabla[Date])=WEEKNUM(today()), CONCATENATE("Week ",Tabla[Week Start Day]),if(WEEKNUM(Tabla[Date])=WEEKNUM(today())-1, CONCATENATE("Week ",Tabla[Week Start Day]),if(WEEKNUM(Tabla[Date])=WEEKNUM(today())-2, CONCATENATE("Week ",Tabla[Week Start Day]), "Rest of the year")))- Your table is something like this:- The result is a table like this:
I hope this works it for you,
Best regards
- AnonymousNot applicable
Thanks, you saved me!
Do you know a way to make only the last three weeks and the cumulative total since 01/01/2022 visible in the table?