Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
instead of showing data from 26 the of june till 1st of June 2024 it shows just 1 june data what should I do
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |