SAMEPERIODLASTYEAR WITH FILTER

[r_fioretti]

Hello everyone, I’m new in the community and I have the following issue:

I’ve created a measure to calculate the increase/decrease over the same period of the previous year. When I use the month in category it’s accumulating the increase/decrease no matter the year of the data.

I’d like to use a filter into the DAX to get the same result I get when I’m using the filter panel or selecting the data on other chart.

The measure I’m using is:

Variação Vendas sobre Ano anterior = sum(Base_de_Dados[Valor Faturado])-

CALCULATE(sum(Base_de_Dados[Valor Faturado]);SAMEPERIODLASTYEAR(Calendario[Data]))

I’ve tried to use an YEAR(MAX(table[date])) and/OR FILTER() into the CALCULATE  function but isn’t working.

Any ideas?

Tks

 

[v-yiruan-msft]

Hi @r_fioretti ,

Please try to create a measure as below:

Variação Vendas sobre Ano anterior =
SUM ( 'Base_de_Dados'[Valor Faturado] )
    - CALCULATE (
        SUM ( 'Base_de_Dados'[Valor Faturado] ),
        DATEADD ( 'Base_de_Dados'[Date], -1, YEAR )
    )

Best Regards

Rena

[r_fioretti]

Hello,
Thank you for your answer, however it didn’t work. When I apply a filter on other report I get an error. 😞

[v-yiruan-msft]

Hi @r_fioretti,

Could you please provide the screenshot with that error info if it is convenient? Thank you.

Best Regards

Rena

[r_fioretti · Accepted solution]

Hello,
I've been able to get the result filtering the visual by TOP N 1 Max Year.

Thank you for your support.

Regards.

[v-yiruan-msft]

Hi @r_fioretti,

Is there anything else that can help you for this thread? If no, could you please mark it as Answered? Thank you.

Best Regards

Rena

[Greg_Deckler]

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...