Total Sales last year and same month's vs. actual year filter.

[Anonymous]

Hi all..

I´m new in the world of powerbi, I tried your 'final' formula but can not get it to work. I am a Beginner and just trying to understand DAX, so I need your help please, I have 2 tables one with the calendar and another with sales of 3 continuous years. The result that I want to obtain is the growth of the year filtered / in the previous year, just like if I filter the month or several months I consider the same months of the last year. My calendar is up to date so from 2017 I only have until 22 march. For now only I have achieved that depending on the filter in the year I get the total sales, but selecting the months nothing happens. If I select any month I compare all the previous year against the month and the year selected, that is wrong. It should be 2017, months January, February vs. 2016 January, February,

 

 Thx for ur time and help.

Gerardo.

[Vvelarde · Accepted solution]

@Anonymous

Hi, please review this PBIX.

I think will help you in your question.

https://drive.google.com/file/d/0B95C8CKdTZE3Z1I5aERLRkczYjg/view?usp=sharing

[Anonymous]

@Vvelarde, it´s a great solution, Make the formulas that come in the file and just for the one of sales shows me information for the one of sales previous year does not show anything, you know to what it is .. my relation between the tables is single and I see that your relation is bidereccional. If I change this relationship in my data model, I will correlate some other relationships I have.

[Vvelarde]

@Anonymous

check the slicers that you use. Both Comes from CalendarTable?

[Anonymous]

the slicers come's from same table Calendar. 😞