Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Community
I have a table similar to the below where i am looking to create a measure that calculates the units for the same Month, Same working day but the previous year.
Date | Working Day | QTY | Vs Previous Year |
01/08/2022 | 1 | 1000 | ? |
02/08/2022 | 2 | 1250 | ? |
05/08/2022 | 3 | 1500 | ? |
Is there a way to acheive this ? I have a date table already set-up with the working day included.
Thanks !
Solved! Go to Solution.
Hi @Caldowd98 ,
Please try
Vs Previous Year =
CALCULATE(
[Sales Amount],
DATEADD('Calendar'[DateKey],-1,YEAR
)
)
Hope that helps, please mark this as a solution if it helps
Regards
Hi @Caldowd98 ,
Please try
Vs Previous Year =
CALCULATE(
[Sales Amount],
DATEADD('Calendar'[DateKey],-1,YEAR
)
)
Hope that helps, please mark this as a solution if it helps
Regards
HI,
Sorry for obvious question but have you tried SAMEPERIODLASTYEAR function (DAX) - DAX | Microsoft Docs
and if so, what error\ issue have you encountered?
The Nick
If the post helps please give a thumbs up || If it solves your issue, please accept it as the solution to help the other members find it more quickly.
If it's the biggest heap of stinky smelly stuff then I'm sorry .
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |