topic Re: CALCULO DO ACUMULADO ANUAL in DAX Commands and Tips

CALCULO DO ACUMULADO ANUAL

Jasminimm — Tue, 11 Jun 2024 17:37:04 GMT

Olá,
Gostaria de ajuda para calcular o valor acumulado anual da variação mensal das despesas, de forma que o acumulado do mês de janeiro é o proprio janeiro e os demais sucessivamente.

Segue a variavel que criei para a variação mensal:
Mas nao consigo fazer ela acumulada

VariacaoMensalPercentual2_SomaAcumulada22 =

SUMX(

'Calendário',

VAR DespesaAtual = SUM(INPC[Realizado])

VAR DespesaAnterior = CALCULATE(

SUM(INPC[Realizado]),

DATEADD('Calendário'[Data], -1, MONTH),

ALLEXCEPT(INPC, INPC[Tipo])

)

RETURN

IF(

NOT ISBLANK(DespesaAnterior),

DIVIDE(DespesaAtual - DespesaAnterior, DespesaAnterior, BLANK()),

BLANK()

) * 100

)

Re: CALCULO DO ACUMULADO ANUAL

lbendlin — Wed, 12 Jun 2024 00:43:03 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523