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.
Hello,
I have a table with revenue by month on several year and i'd like to compare the growth of the revenu of the current month vs january of the same year. Is it possible to do that please?
Solved! Go to Solution.
Try this MEASURE
Please see attached file as well
Growth Measure = VAR mymonth = SELECTEDVALUE ( 'Calendar'[Date].[MonthNo] ) - 1 VAR Jan_Same_year = CALCULATE ( SUM ( Table1[Sales] ), DATEADD ( 'Calendar'[Date], - mymonth, MONTH ) ) RETURN DIVIDE ( SUM ( Table1[Sales] ), Jan_Same_year ) - 1
Try this MEASURE
Please see attached file as well
Growth Measure = VAR mymonth = SELECTEDVALUE ( 'Calendar'[Date].[MonthNo] ) - 1 VAR Jan_Same_year = CALCULATE ( SUM ( Table1[Sales] ), DATEADD ( 'Calendar'[Date], - mymonth, MONTH ) ) RETURN DIVIDE ( SUM ( Table1[Sales] ), Jan_Same_year ) - 1
Thank you your solution work
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |