Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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] ) ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |