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.
I have this sales and date table below and I was wondering if it would be possible to create a measure that shows me the total sales for the last week but only for the same amount of days. So for example we are in day 3 this week and i'd like to see the sales for the same 3 days last week if that makes sense. I'm able to do it for month because there are actual month related formulas in power bi but there is nothing for week as far as i'm aware.
Date | Week | Revenue |
29/11/2020 | 49 | 5,000 |
30/11/2020 | 49 | 6,000 |
01/12/2020 | 49 | 3,000 |
02/12/2020 | 49 | 2,000 |
03/12/2020 | 49 | 6,000 |
04/12/2020 | 49 | 1,000 |
05/12/2020 | 49 | 1,000 |
06/12/2020 | 50 | 1,000 |
07/12/2020 | 50 | 2,000 |
08/12/2020 | 50 | 3,000 |
09/12/2020 | 50 | 4,000 |
10/12/2020 | 50 | 5,000 |
11/12/2020 | 50 | 6,000 |
12/12/2020 | 50 | 7,000 |
13/12/2020 | 51 | 7,000 |
14/12/2020 | 51 | 7,000 |
15/12/2020 | 51 | 7,000 |
What I'd like it to look like is this:
Week | Revenue | Revenue Same period last week |
50 | 28,000 | 24,000 |
51 | 21,000 | 6,000 |
Solved! Go to Solution.
@hiran , refer my formula of Week till date in Video or blog
Power BI — Week on Week and WTD -https://www.youtube.com/watch?v=pnAesWxYgJ8
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
@hiran , refer my formula of Week till date in Video or blog
Power BI — Week on Week and WTD -https://www.youtube.com/watch?v=pnAesWxYgJ8
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
Hello Amit, what about week to date till yesterday and same for previous week?
@amitchandak Thank you so much it works! If I wanted to do it the same for last month would i need to do a month rank?
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 |
---|---|
111 | |
107 | |
88 | |
76 | |
67 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |