Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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().
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
28 | |
22 |