Forum Discussion
SAMEPERIODLASTYEAR based on Running Days
Hi All, Refer the below Simplified example. So, I need to go back to PREVIOUS YEAR SAME QUARTER and based on Running day number, need to get the Total Sales value. If I use SAME PER...
vijay273162 , Not very clear, Do you want to compare Week day of this with same weeikday last year ?
that will like
week Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAY))
Or do want work across work days
Traveling Across Workdays - What is next/previous Working day
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calendar-4-5-Power/ba-p/1187766