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 Experts,
I've been having trouble calculating the growth percentage of my YTD totals compared to the same period last year. Both the "YTD Amount Converted" and "Total Sum of Converted LY" numbers and totals are showing correctly but as you can see the % is off.
For the "YTD Converted YOY%" I am using the following DAX formula. I am hoping you can help me with a different formula that would give the accurate % change between the Current YTD total vs. the same time period of the previous year.
YTD (Converted) for all Opps YoY% =
VAR __PREV_YEAR =
CALCULATE(
[Amount (Converted) for all Opps],
DATEADD('Opportunity'[CreatedDate].[Date], -1, YEAR)
)
RETURN
DIVIDE([Amount (Converted) for all Opps] - __PREV_YEAR, __PREV_YEAR)
Thank you so much!
Solved! Go to Solution.
Thank you @v-yuezhe-msft
Here is the formula I used to calculate [Amount (Converted) for all Opps]:
Amount (Converted) for all Opps =
CALCULATE(
SUM(Opportunity[Amount (Converted)]),
'Opportunity'[StageName (groups)] <> "Closed Won"
)
For 2018, the value for [Amount (Converted) for all Opps] is showing as expected which is:
January: 1,773,951.25
February: 859,270.97
March: 1,029,055.84
TotalYTD = 3,662,278.06
@jnorth,
What formula do you use to calculate [Amount (Converted) for all Opps]? What is your expected result about the total value of [Amount (Converted) for all Opps]?
Regards,
Lydia
Thank you @v-yuezhe-msft
Here is the formula I used to calculate [Amount (Converted) for all Opps]:
Amount (Converted) for all Opps =
CALCULATE(
SUM(Opportunity[Amount (Converted)]),
'Opportunity'[StageName (groups)] <> "Closed Won"
)
For 2018, the value for [Amount (Converted) for all Opps] is showing as expected which is:
January: 1,773,951.25
February: 859,270.97
March: 1,029,055.84
TotalYTD = 3,662,278.06
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 |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |