Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Hi @tsimon21 ,
Create calculated colunm and modify formual like below:
week = WEEKDAY('Table'[Date],2)
result_ =
VAR cur_ =
CALCULATE (
SUM ( 'Table'[Total Volume] ),
DATESBETWEEN ( 'Table'[Date], TODAY (), TODAY () )
)
VAR sel_ =
SELECTEDVALUE ( slicer[Week] )
VAR week_ =
WEEKDAY ( TODAY () - sel_, 2 )
VAR last_sel_week =
CALCULATE (
SUM ( 'Table'[Total Volume] ),
DATESBETWEEN ( 'Table'[Date], TODAY () - sel_, TODAY () - sel_ ),
FILTER ( 'Table', 'Table'[week] = week_ )
)
RETURN
DIVIDE ( cur_ - last_sel_week, last_sel_week )
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @tsimon21 ,
Thanks for the reply from @lbendlin , please allow me to provide another insight.
You need to use the date function correctly, refer to the following formula:
result_ =
VAR cur_ =
CALCULATE (
SUM ( 'Table'[Total Volume] ),
DATESBETWEEN ( 'Table'[Date], TODAY (), TODAY () )
)
VAR sel_ =
SELECTEDVALUE ( slicer[Week] )
VAR last_sel_week =
CALCULATE (
SUM ( 'Table'[Total Volume] ),
DATESBETWEEN ( 'Table'[Date], TODAY () - sel_, TODAY () - sel_ )
)
RETURN
DIVIDE ( cur_ - last_sel_week, last_sel_week )
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This gets me close, but I can only view vs 1 prior week. I need the combined past 4 fridays vs the current. For example: 3/22 compared to Average of (3/15, 3/8, 3/1, 2/23), and this needs to be dynamic so it moves with each new day
Hi @tsimon21 ,
Create calculated colunm and modify formual like below:
week = WEEKDAY('Table'[Date],2)
result_ =
VAR cur_ =
CALCULATE (
SUM ( 'Table'[Total Volume] ),
DATESBETWEEN ( 'Table'[Date], TODAY (), TODAY () )
)
VAR sel_ =
SELECTEDVALUE ( slicer[Week] )
VAR week_ =
WEEKDAY ( TODAY () - sel_, 2 )
VAR last_sel_week =
CALCULATE (
SUM ( 'Table'[Total Volume] ),
DATESBETWEEN ( 'Table'[Date], TODAY () - sel_, TODAY () - sel_ ),
FILTER ( 'Table', 'Table'[week] = week_ )
)
RETURN
DIVIDE ( cur_ - last_sel_week, last_sel_week )
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I don't see in your formula where you subtract 1,8,15,22,29 from TODAY().
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
54 | |
24 | |
23 | |
15 | |
11 |
User | Count |
---|---|
76 | |
59 | |
46 | |
17 | |
12 |