topic Re: Weekly data analyzing in DAX Commands and Tips

Weekly data analyzing

Mniknejad — Fri, 26 Jul 2024 16:53:30 GMT

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

Re: Weekly data analyzing

MalkhazTsagarel — Sat, 27 Jul 2024 11:43:15 GMT

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

Re: Weekly data analyzing

Mniknejad — Mon, 29 Jul 2024 15:03:33 GMT

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