Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there
I have a Date table as below and some measurements with SalesVolume and the percentage changes example YOY %
How do I show the previous Fiscal Year Week Number YoY % value in a card, example 62.75%
Solved! Go to Solution.
Hi @okl ,
You can filter the previous week by subtracting the current week number by one.
For example, if you need to return sales for the previous week, you can create a measure.
PreviousWeek =
CALCULATE (
SUM ( 'Table'[Sales] ),
FILTER (
ALLSELECTED ( 'Table' ),
[Fiscal Year Week Number]
= MAX ( 'Table'[Fiscal Year Week Number] ) - 1
)
)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @okl ,
You can filter the previous week by subtracting the current week number by one.
For example, if you need to return sales for the previous week, you can create a measure.
PreviousWeek =
CALCULATE (
SUM ( 'Table'[Sales] ),
FILTER (
ALLSELECTED ( 'Table' ),
[Fiscal Year Week Number]
= MAX ( 'Table'[Fiscal Year Week Number] ) - 1
)
)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |