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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |