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 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.
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |