Forum Discussion
Helper VPercentage achievement
Hey people,
I'm trying to create a measure that selects the date when 40% of the sale is reached. In the example below the 40% was reached in July 2023.
How do I select this date?
To create the matrix I used month and year from my calendar table. And for the percentage measure:
40% =
VAR PercentualCurva = DIVIDE(projetoAcumulado,_allProjeto)
RETURN
IF( PercentualCurva >= 0.4, MIN(ultimoReaalDivulgado[Data Repasse]))
Hi,
Please find attached my solution file.
Hope this helps.
7 Replies
- Ashish_Mathur
Super User
Hi,
Share the download link of the PBI file. Do you want to see this date for each project? If possible, please ensure column/table names are in English.
kasifeHi Ashish_Mathur
yes, I would like to have a list with the date of each project.From it I will also create a conditional with color until it reaches 40% which is the beginning of the project.
Here the pbix:
- Ashish_Mathur
Hi,
Please find attached my solution file.
Hope this helps.