cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
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%

 

Untitled.png

 

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:

 

error.png

 

 

Thank you.

 

 

 

 
 
 
 

 

 

 

 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
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 🙂

YouTube, LinkedIn

View solution in original post

2 REPLIES 2
Highlighted
Community Champion
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 🙂

YouTube, LinkedIn

View solution in original post

Highlighted
Super User IV
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]) )

 

Power BI — YTD
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
Power BI — QTD
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
Power BI — MTD
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

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