Show a column and his equivalent from last year

[Bastienlin_]

Hello PBI community,

I am having trouble trying to simply show a column from last year when I select a date on my slicer
Here is an example of my data:

Name	Date
Coca	2019
Fanta	2019
Ice Tea	2019
Pepsi	2020
Fanta	2020
Ice Tea	2020
Sprite	2020

• How can I create a dax measure that will show below table, if I select 2020 in my slicer:

Name	Date
Coca	2019
Fanta	2019
Ice Tea	2019

• And is it possible to show what are the differences between 2020 and the previous year ? For example, the differences we can see here from 2019 to 2020, is that Coca is missing, and Pepsi & Sprite have been added.
  
  Thank you for your help !
  
  

[amitchandak]

@Bastienlin_ , With separate date/year table, use these type of measures with name

This Year = CALCULATE(Count('Table'[Name]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(Count('Table'[Name]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

[Bastienlin_]

Hi @amitchandak thank you for your answer.

Nevertheless, your measure seems to only count the rows from a year and another. What I would like is to show the list of the column Names from a year and also the previous one.
If i select 2020 in my slicer, i want to show:

Name	Date
Coca	2019
Fanta	2019
Ice Tea	2019

And do you have an idea for my second point: "is it possible to show what are the differences between 2020 and the previous year ? For example, the differences we can see here from 2020 and the previous year, are that Coca is missing, and Pepsi & Sprite have been added."