Sum of of last week value from selected week

[peoplehelpme]

hi people . please help me to create 

sum of last week data from selected week

i got this date table

Date	Week number	Week text
2021-01-03	1	W1
2021-01-10	2	W2
2021-01-17	3	W3
2021-01-24	4	W4
2021-01-31	5	W5
2021-02-07	6	W1
2021-02-14	7	W2
2021-02-21	8	W3
2021-02-28	9	W4

and this data table (these two table are not connect in any relationship)

date	name	value
2021-01-03	a	1
2021-01-03	b	2
2021-01-10	c	3
2021-01-10	d	4
2021-01-10	e	5
2021-01-17	f	6
2021-01-17	g	7
2021-02-07	h	8
2021-02-07	i	9

when i select Jan-2021- W2 (these are 3 filters)

i want to get value 

last week=3

this week=12

another question is how can i do if i want to show item name

when i select Jan-2021- W2

i want to show data

last week=a,b

this week=c,d,e

[ryan_mayu · Accepted solution]

@peoplehelpme 

pls try to create 4 measure

last week value =

var _date=maxx(FILTER(all('Table'),'Table'[Date]<max('Table'[date])),'Table'[date])

return sumx(FILTER('Table 2','Table 2'[Date]=_date),'Table 2'[value])

this week value = sumx(FILTER('Table 2','Table 2'[Date]=max('Table'[Date])),'Table 2'[value])

last week item =

var _date=maxx(FILTER(all('Table'),'Table'[Date]<max('Table'[date])),'Table'[date])

return CONCATENATEX(FILTER('Table 2','Table 2'[Date]=_date),'Table 2'[name],",")

this week item = CONCATENATEX(FILTER('Table 2','Table 2'[Date]=max('Table'[Date])),'Table 2'[name],",")

pls see the attachment below

[peoplehelpme]

Sorry sir, I got a problem of this formula, look like it doesnt work on some week selected

last week value =

var _date=maxx(FILTER(all('Table'),'Table'[Date]<max('Table'[date])),'Table'[date])

return sumx(FILTER('Table 2','Table 2'[Date]=_date),'Table 2'[value]) ,

here is example of table1

Date	weeknum	weektext	year	month
2024-04-07	171	W1	2024	apr
2024-04-14	172	W2	2024	apr
2024-04-21	173	W3	2024	apr
2024-04-28	174	W4	2024	apr
2024-05-05	175	W1	2024	may
2024-05-12	176	W2	2024	may
2024-05-19	177	W3	2024	may
2024-05-26	178	W4	2024	may
2024-06-02	179	W1	2024	jun

and then i got data table

name	date	value	weeknum
a	2024-04-07	1	171
b	2024-04-14	2	172
c	2024-04-28	3	174
d	2024-04-28	4	174
e	2024-05-05	5	175
f	2024-05-05	6	175
g	2024-05-12	7	176
h	2024-05-12	8	176
i	2024-05-12	9	176

somehow when i select 2024,may, w1 ,

the value of last week should be 7 but this formula give me 10 which is wrong please help me

[ryan_mayu]

@peoplehelpme 

i didn't change any DAX, the output is 7, pls see the attachment below

pls see the attachment below