Forum Discussion

Mniknejad's avatar
Mniknejad
Frequent Visitor
2 years ago

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 

Weekly data analyzing Power BI

2 Replies

  • MalkhazTsagarel's avatar
    MalkhazTsagarel
    Regular Visitor
    2 years ago

    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's avatar
      Mniknejad
      Frequent Visitor
      2 years ago

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