How can I accumulate a % in dates in DAX?

[emadrigals104]

Hi everyone, 

I am trying to perform a function that allows me to accumulate the percentage, but not using the traditional method with DATESYTD, because it takes the amounts and not the results of the monthly percentages.

The idea is to create both measure 1, as well as measure 2, which is the one that accumulates.

I appreciate your help.

[v-yanjiang-msft · Accepted solution]

Hi @emadrigals104 ,

According to your description, here's my solution.

Create two measures.

Measure1 = DIVIDE(MAX('Table'[Value2]),MAX('Table'[Value1]))

Measure2 =
SUMX (
    FILTER ( ALL ( 'Table' ), 'Table'[Date] <= MAX ( 'Table'[Date] ) ),
    [Measure1]
)

Get the result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.