cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Post Patron

## Divide Monthly % by Month Number

Hello,

Need your help in creating a measure/column that computes the YTD%.

The formula of YTD% is Total Monthly Percentage / Filtered Month

For example:

Service: Balance Inquiry

Month filtered: April 2020

(January 2020 = 97.44) + (February 2020 = 97.58) + (March= 100.00) + (April 2020 = 99.56) / Month Selected (April 2020 = 4)

YTD % = 98.65%

But I am encountering an error with my YTD% formula when putting it as a line in my combination chart. Since my column series is my Month.  Below are my formula and error encountered:

My formula: FINAL YTD = CALCULATE( [YTD%] / DIM_DATE[Month_No])

Error:

Thank you.

1 ACCEPTED SOLUTION
Super User

@icdns

Can you this measure:

``````My formula: FINAL YTD =
DIVIDE(
[YTD%],
MAX(DIM_DATE[Month_No])
) ``````

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

Did I answer your question? Mark my post as a solution! and hit thumbs up
2 REPLIES 2
Super User

@icdns , you can try

divide( [YTD%] ,distinctcount( DIM_DATE[Month_No]) ) //Better take month year -- Safe id one month is missing

divide( [YTD%] ,Max( DIM_DATE[Month_No]) )

Super User

@icdns

Can you this measure:

``````My formula: FINAL YTD =
DIVIDE(
[YTD%],
MAX(DIM_DATE[Month_No])
) ``````

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

Did I answer your question? Mark my post as a solution! and hit thumbs up

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors