Forum Discussion

icdns's avatar
icdns
Icon for Post Patron rankPost Patron
6 years ago
Solved

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.

 

 

 

 
 
 
 

 

 

 

 
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    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

2 Replies