Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
pls try to create 4 measure
Proud to be a Super User!
pls try to create 4 measure
Proud to be a Super User!
Sorry sir, I got a problem of this formula, look like it doesnt work on some week selected
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 |
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
i didn't change any DAX, the output is 7, pls see the attachment below
pls see the attachment below
Proud to be a Super User!
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |