79078567

Date: 2024-10-11 14:11:08
Score: 0.5
Natty:
Report link

I was able to solve the issue using the measure for the current year as a base and using the SAMEPERIODLASTYEAR function with a filter:

AnoAnteriorFaturamentoYeartodate = 

VAR FinalMesAtualAnoAnterior = 
    CALCULATE(
        MAX(tb_Calendario_Faturamento[Data]),
        YEAR(tb_Calendario_Faturamento[Data]) = YEAR(TODAY()) - 1 &&
        MONTH(tb_Calendario_Faturamento[Data]) <= MONTH(TODAY()) 
    )

RETURN
CALCULATE(    
    [Faturamento Acumulado Atual],
    SAMEPERIODLASTYEAR(tb_Calendario_Faturamento[Data])
    ,tb_Calendario_Faturamento[Data]<=FinalMesAtualAnoAnterior
)
Reasons:
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Felipe Augusto Violin