Need your help in creating a measure/column that computes the YTD%.
The formula of YTD% is Total Monthly Percentage / Filtered Month.
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])
Go to Solution.
@icdns Can you this measure:
My formula: FINAL YTD =
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 🙂
View solution in original post
@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://email@example.com/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38aPower BI — QTD https://firstname.lastname@example.org/power-bi-qtd-questions-time-intelligence-2-5-d842063da839Power BI — MTD https://email@example.com/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.