DAX Sameperiodelastyear filter on day name

[JeroenR]

Hi,

I want to know the amount of last year based on the dayname. I thought that it would be possible with sameperiodelastyear but this dax function calculates on date and not on day name. 

Let say we take the following date: monday 16 march 2020. I want to compare the results of this date based on the exact date WITH day name of last year. So that would be monday 18 march 2019. 

Is this possible with the sameperiodelastyear dax function and with some kind of filter that checks on the day name?

[amitchandak · Accepted solution]

Week year is 364 days behind

Week Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAY))

Make sure you use date calendar for this

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

[JeroenR]

Thank you, this works! I was thinking too complicated and thought that it could also work with the sameperiodlastyear function.