Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Mniknejad
Frequent Visitor

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 
Mniknejad_0-1722012733803.png

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

2 REPLIES 2
MalkhazTsagarel
Regular Visitor

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

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.