Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Im using this and it works perfect: DIVIDE(SUM(Vista_TGT[Cantidad]), CALCULATE(SUM(Vista_TGT[Cantidad]), ALL(Vista_TGT[Expr3])))
So Im getting the percentage right
But I need the same dax but this time with the PREVIOUSYEAR function...I tried this and didnt work: DIVIDE(SUM(Vista_TGT[Cantidad]),CALCULATE(SUM(Vista_TGT[Cantidad])),PREVIOUSYEAR(Vista_TGT[Fecha]),ALL(Vista_TGT[Expr3]))
Any idea how to fix it?
I would really appreciate your guys help or advices!!!!!!!
Solved! Go to Solution.
You may add another measure as shown below.
Measure 2 = CALCULATE ( [Measure], PREVIOUSYEAR ( Vista_TGT[Fecha] ) )
You may add another measure as shown below.
Measure 2 = CALCULATE ( [Measure], PREVIOUSYEAR ( Vista_TGT[Fecha] ) )
I believe you need SAMEPERIODLASTYEAR.
Try replacing PREVIOUSYEAR with SAMEPERIODLASTYEAR
Didnt Work 😞
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |