Percentage achievement

[kasife]

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

 

[Ashish_Mathur]

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.

[kasife]

Hi @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: 

https://ufile.io/rnzyxdqo

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached my solution file.

Hope this helps.

[kasife]

@Ashish_Mathur 

This is perfect! Thank you very much.

If I wanted to do it for the project without using modules, what measure would I have to adjust?

[Ashish_Mathur]

You are welcome.  If my previous reply helped, please mark that reply as Answer.  From visual on the left, just drag out the Module.

Hope this helps.

[kasife]

Thanks so much @Ashish_Mathur 

[Ashish_Mathur]

You are welcome.