want to show previous week data after selecting week

[peoplehelpme]

hi guys imagine if i click week1 it will show data of last week of the previous month, please tell me to do that,

in this example below. the present data is week1=128.76 , but if i want to show is when i click w2 it will show 128.76

[v-kongfanf-msft]

Hi @peoplehelpme ,

Please describe your requirements along with relevant test data.

Best Regards,
Adamk Kong

[v-kongfanf-msft]

Hi @peoplehelpme ,

You need to create a date table and then establish a one-to-many relationship with your data table. Then create the following:

Date = 
ADDCOLUMNS (
    CALENDAR ( DATE ( 2023, 01, 01 ), DATE ( 2024, 12, 31 ) ),
    "Year", YEAR ( [Date] ),
    "Quarter", ROUNDUP ( MONTH ( [Date] ) / 3, 0 ),
    "Month", MONTH ( [Date] ),
    "Week", WEEKNUM ( [Date] ),
    "Year-Qur",
        YEAR ( [Date] ) & "Q"
            & ROUNDUP ( MONTH ( [Date] ) / 3, 0 ),
    "Year-Mon",
        YEAR ( [Date] ) * 100
            + MONTH ( [Date] ),
    "Year-Week",
        YEAR ( [Date] ) * 100
            + WEEKNUM ( [Date], 2 ),
    "Weekday", WEEKDAY ( [Date], 2 )
)

result_ = 
VAR sel_year =
    SELECTEDVALUE ( 'Date'[Year] )
VAR sel_mon =
    SELECTEDVALUE ( 'Date'[Month] )
VAR sel_week =
    SELECTEDVALUE ( 'Date'[Week] )
VAR sel_min =
    CALCULATE (
        MIN ( 'Table'[Date] ),
        FILTER ( 'Date', sel_year && sel_mon && sel_week )
    )
VAR sel_max =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( 'Date', sel_year && sel_mon && sel_week )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[Value] ),
        DATESBETWEEN ( 'Date'[Date], sel_min - 7, sel_min - 1 )
    )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[peoplehelpme]

what column i need to create relationship

[v-kongfanf-msft]

Hi @peoplehelpme ,

Please provide your data model.

Best Regards,
Adamk Kong

[peoplehelpme]

[peoplehelpme]

sorry for unclear target, i string column too