Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I'd llike to calculate : (expense 2017 - expense 2016) x (volume 2017 - volume 2016).
I have a problem because of the sameperiodlastyear filter, it is not possible to use it twice on the same formula.
Thank you 🙂
Solved! Go to Solution.
@Thomas897 wrote:
Hi everyone,
I'd llike to calculate : (expense 2017 - expense 2016) x (volume 2017 - volume 2016).
I have a problem because of the sameperiodlastyear filter, it is not possible to use it twice on the same formula.
Thank you 🙂
You can try to create a measure as
Measure = ( SUM ( Table1[expense] ) - CALCULATE ( SUM ( Table1[expense] ), SAMEPERIODLASTYEAR ( 'calendar'[Date] ) ) ) / ( SUM ( Table1[volume] ) - CALCULATE ( SUM ( Table1[volume] ), SAMEPERIODLASTYEAR ( 'calendar'[Date] ) ) )
@Thomas897 wrote:
Hi everyone,
I'd llike to calculate : (expense 2017 - expense 2016) x (volume 2017 - volume 2016).
I have a problem because of the sameperiodlastyear filter, it is not possible to use it twice on the same formula.
Thank you 🙂
You can try to create a measure as
Measure = ( SUM ( Table1[expense] ) - CALCULATE ( SUM ( Table1[expense] ), SAMEPERIODLASTYEAR ( 'calendar'[Date] ) ) ) / ( SUM ( Table1[volume] ) - CALCULATE ( SUM ( Table1[volume] ), SAMEPERIODLASTYEAR ( 'calendar'[Date] ) ) )
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |