Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI @Anonymous
I want to get the previous week sales amount and get the difference between this week sales and previous week sales. How can i get that?
Regards,
Cham
Hi @cham ,
First you need to have a table with a calendar.
table = Calendar (dateStart;dateEnd)
After creat new column
WeekNum = WEEKNUM('calendar'[Date];2)
where 2 -start week on Monday
Create relationsship you table "Fact" with table "Calendar" through date.
New measure: Fact(WeekNow) ,
Fact_weekNow = calculate(sum(fact); filter(Calendar;calendar[weekNum] = WEEKNUM(max('Fact'[Date]);2))
Fact_weekPr = calculate(sum(fact); filter(Calendar;calendar[weekNum] = WEEKNUM(max('Fact'[Date]);2)-1)
WeekNowVSWeekPr= Fact_weekNow /Fact_weekPr -1
Filter for weeks should be used from the calendar table, then you can see empty weeks if you need look fact at period
Hi @Anonymous
I want to know why you use 2 for followings,
WeekNum = WEEKNUM('calendar'[Date];2)
where 2 -start week on Monday
Fact_weekNow = calculate(sum(fact); filter(Calendar;calendar[weekNum] = WEEKNUM(max('Fact'[Date]);2))
Fact_weekPr = calculate(sum(fact); filter(Calendar;calendar[weekNum] = WEEKNUM(max('Fact'[Date]);2)-1)
In my data set i have client details. I want to get the difference betweeen previous week client values with this week.
- In your formula you used sum(fact) so in my formula do i need to use sum(clients) ?
- Do i need to create a seperate calender to calculate the data?
regards,
cham
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
112 | |
96 | |
94 | |
64 | |
58 |