Forum Discussion
DAX Query - Temp Table Filter Measure - Previous Year Sum
Hi Community, Im looking to create a Temp Table In Dax that collects a date range and be able to specify such range in lower measure, Is there a way to do this? The code I have is the follow...
Hi Amit,
This code would get the same Date for Previous Year, however the Day is different Today is 07/12/2021 this would get Tuesday for Last year this was Monday 07/12/2020 The Requirement is to get the same Days Sales Which would be Tuesday. Maybe its just my organisation but there needs to be a SameDayLastYear Function in Dax for this requirement.