comparing day wise sales with previous year

[Anonymous]

How can I compare this year sales with exactly the same weekday sales of last year. Take for instance, Today is October 1st 2015 i must compare today sales with sales on October 2nd 2014 because this two days are thursdays of the same week and month.  And i also want to assign the comparable days as "P" and non comparable days as "T". Say here 1st october 2014 and 31st october 2015 as "T" and the rest is "P". help me.

[Anonymous]

You need to have a column in your data table that will allow DAX to "know" what the previous day to compare to was. Do you have a date table?

[Anonymous]

Thank you @Anonymous . Yes i am having a date column with date from 2018/01/01 to today along with the list of columns containing weekdays, days, weekday no, year 

[Anonymous]

Thank you for your reply nick. Yes i am having a date column with date from 2018/01/01 to today along with the list pof columns containing weekdays, days, weekday no, year