Weekly data analyzing
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
