Weekly data analyzing

[Mniknejad]

I have a report that's Daily Dashboard and now they are asking to show a new column that shows Weekly revenue 

I've used this 

WeekToDateRevenue =

VAR StartOfSelectedWeek =

    CALCULATE(MIN('Fiscal Date'[CALENDAR_DATE]),FILTER(all('Fiscal Date'),'Fiscal Date'[CALENDAR_DATE] >= [SelectedDate] - WEEKDAY([SelectedDate], 2) + 1))

VAR Cur =

    IF (

        SELECTEDVALUE ( 'Currency'[Currency] ) = "Local",

        CALCULATE (

            [Daily Revenue]  ,

            FILTER( 'Fiscal Date', 'Fiscal Date'[CALENDAR_DATE] >= StartOfSelectedWeek )

        ),

        CALCULATE (

            [Net Amount Posted (Retail Trans)],

            FILTER( Items, Items[CalculatedSalesFlag] = "Y" ),

            FILTER( ActivityType, ActivityType[ActivityTypeID] IN {2, 19} ),

            FILTER( 'Retail Transactions', 'Retail Transactions'[TransactionStatus] IN {"Posted", "None"} ),

            FILTER( 'Fiscal Date', 'Fiscal Date'[CALENDAR_DATE] >= StartOfSelectedWeek && 'Fiscal Date'[CALENDAR_DATE] <= [SelectedDate] )

        )

    )

RETURN

    Cur

but it's not show me the weekly data it will show me the daily data base on Date filter that I have on my report 

instead of showing data from 26 the of june till 1st of June 2024 it shows just 1 june data what should I do 

[MalkhazTsagarel]

Hey,
Maybe This will Help:
WeekToDateRevenue =
VAR StartOfSelectedWeek =
CALCULATE(
MIN('Fiscal Date'[CALENDAR_DATE]),
FILTER(
ALL('Fiscal Date'),
'Fiscal Date'[CALENDAR_DATE] >= [SelectedDate] - WEEKDAY([SelectedDate], 2) + 1
)
)
VAR EndOfSelectedWeek =
CALCULATE(
MAX('Fiscal Date'[CALENDAR_DATE]),
FILTER(
ALL('Fiscal Date'),
'Fiscal Date'[CALENDAR_DATE] <= [SelectedDate] - WEEKDAY([SelectedDate], 2) + 7
)
)
VAR Cur =
IF(
SELECTEDVALUE('Currency'[Currency]) = "Local",
CALCULATE(
[Daily Revenue],
FILTER(
'Fiscal Date',
'Fiscal Date'[CALENDAR_DATE] >= StartOfSelectedWeek &&
'Fiscal Date'[CALENDAR_DATE] <= EndOfSelectedWeek
)
),
CALCULATE(
[Net Amount Posted (Retail Trans)],
FILTER(Items, Items[CalculatedSalesFlag] = "Y"),
FILTER(ActivityType, ActivityType[ActivityTypeID] IN {2, 19}),
FILTER('Retail Transactions', 'Retail Transactions'[TransactionStatus] IN {"Posted", "None"}),
FILTER(
'Fiscal Date',
'Fiscal Date'[CALENDAR_DATE] >= StartOfSelectedWeek &&
'Fiscal Date'[CALENDAR_DATE] <= EndOfSelectedWeek
)
)
)
RETURN
Cur

[Mniknejad]

no ididn't fix the issuestill daily amount and week to date amount is same