topic Re: How can I accumulate a % in dates in DAX in DAX Commands and Tips

How can I accumulate a % in dates in DAX

emadrigals104 — Thu, 09 Jun 2022 16:04:47 GMT

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.

Re: How can I accumulate a % in dates in DAX

Jihwan_Kim — Thu, 09 Jun 2022 17:14:06 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

Expected measure: = CALCULATE ( SUMX ( Data, Data[Value2] / Data[Value1] ), FILTER ( ALL ( Data ), Data[Date] <= MAX ( Data[Date] ) ) )

Re: How can I accumulate a % in dates in DAX

tamerj1 — Thu, 09 Jun 2022 17:17:38 GMT

Hi emadrigals104

please try

Measure1 Correct Total = SUMX ( VALUES ( 'Date'[Month] ), [Measure1] )