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])-
I’ve tried to use an YEAR(MAX(table[date])) and/OR FILTER() into the CALCULATE function but isn’t working.
Solved! Go to Solution.
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 ) )
Could you please provide the screenshot with that error info if it is convenient? Thank you.
Is there anything else that can help you for this thread? If no, could you please mark it as Answered? Thank you.
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!