cancel
Showing results for
Did you mean:
Highlighted
Helper V

## 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

Accepted Solutions
Highlighted
Community Champion

@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 🙂

2 REPLIES 2
Highlighted
Community Champion

@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 🙂

Highlighted
Super User IV

@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]) )

Proud to be a Super User!

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors