Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I got another question
is it possible to calculate the difference within one column between two months?
E.g.
Month: January
Product launch: 5
Month: February
Product launch: 7
--> calculate in new column the difference between "Product launch" February and "Product launch" January:
7-5 = +2
Maybe anybody know a solution.
Thank you in advance!
Julia
Solved! Go to Solution.
Hi @JuliaWendel
Try this solution.
If you donot have a column for Month Numbers... add this calculated column
Month_Number = SWITCH ( Table1[Months], "January", 1, "February", 2, "March", 3, "April", 4, "May", 5, "June", 6, "July", 7, "August", 8, "September", 9, "October", 10, "November", 11, "December", 12 )
Now you can get the desired difference column using below
Difference = VAR PreviousMonthValue = CALCULATE ( SUM ( Table1[Product Launch] ), FILTER ( ALL ( Table1 ), Table1[Month Number] = EARLIER ( Table1[Month Number] ) - 1 && Table1[Year] = EARLIER ( Table1[YEAR] ) ) ) VAR PreviousMonthValueforJan = CALCULATE ( SUM ( Table1[Product Launch] ), FILTER ( ALL ( Table1 ), Table1[Month Number] = 12 && Table1[Year] = EARLIER ( Table1[YEAR] ) - 1 ) ) RETURN Table1[Product Launch] - IF ( Table1[Month_Number] = 1, PreviousMonthValueforJan, PreviousMonthValue )
Hi @JuliaWendel,
Have you tried the solution provided by @Zubair_Muhammad above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here.
Regards
Hi @JuliaWendel,
Have you tried the solution provided by @Zubair_Muhammad above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here.
Regards
Hi @JuliaWendel
Try this solution.
If you donot have a column for Month Numbers... add this calculated column
Month_Number = SWITCH ( Table1[Months], "January", 1, "February", 2, "March", 3, "April", 4, "May", 5, "June", 6, "July", 7, "August", 8, "September", 9, "October", 10, "November", 11, "December", 12 )
Now you can get the desired difference column using below
Difference = VAR PreviousMonthValue = CALCULATE ( SUM ( Table1[Product Launch] ), FILTER ( ALL ( Table1 ), Table1[Month Number] = EARLIER ( Table1[Month Number] ) - 1 && Table1[Year] = EARLIER ( Table1[YEAR] ) ) ) VAR PreviousMonthValueforJan = CALCULATE ( SUM ( Table1[Product Launch] ), FILTER ( ALL ( Table1 ), Table1[Month Number] = 12 && Table1[Year] = EARLIER ( Table1[YEAR] ) - 1 ) ) RETURN Table1[Product Launch] - IF ( Table1[Month_Number] = 1, PreviousMonthValueforJan, PreviousMonthValue )
Thank you 🙂
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |