Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I'm going to break my issue into two steps:
1. July being the first month of Fiscal year. I need to find the difference between value every month with July:
Eg: Month Value Difference
July 10 0
Aug 30 20
Sep 20 10
Oct 10 0
Something like above.
2. My second step is to find the sum of the difference column above.
Sum= 0+20+10+0=30
Any help would be appreciated.
Thanks in Advance.
Bhavya
Solved! Go to Solution.
hello @Anonymous
try something like this and let me know if it works for yout scenario:
Distribution Difference = SUMX( SUMMARIZE( 'Calendar', 'Calendar'[Year], 'Calendar'[Year Month] ), CALCULATE( SUM( Distributions[Distribution] ) ) - CALCULATE( SUM( Distributions[Distribution] ), STARTOFYEAR( 'Calendar'[Date], "06/30") ) )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hi @Anonymous
are you able to post a sample of your data? is it aggregated by month?
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hi,
Thanks for your response. Below is how my data looks:
First I need to find the difference between each month data and July data and then find the sum of that difference to show it in another table.
YearMonth | Distribution |
Jul-18 | 172406 |
Aug-18 | 168617 |
Sep-18 | 168061 |
Oct-18 | 145094 |
Nov-18 | 98080 |
Hello @Anonymous
are you looking to create a new calculated table with the data or in a matrix ?
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
In a Matrix table.
hello @Anonymous
try something like this and let me know if it works for yout scenario:
Distribution Difference = SUMX( SUMMARIZE( 'Calendar', 'Calendar'[Year], 'Calendar'[Year Month] ), CALCULATE( SUM( Distributions[Distribution] ) ) - CALCULATE( SUM( Distributions[Distribution] ), STARTOFYEAR( 'Calendar'[Date], "06/30") ) )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Thank You @LivioLanzo. Below formula worked for me. Something similar to what you have mentioned.