Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

SAMEPERIODLASTYEAR - working with week ending dates

I have a dataset that goes by week ending dates e.g. every sale made between 01/10/2018 - 07/10/2018 (dd-mm-yyyy) will have the date 07/10/2018 (last day of week 40 in 2018). When I use SAMEPERIODLA...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi jd009,

 

"I would like to, ideally, determine which week majority of the LY date range sits in, then adjust the LY week/date-range accordingly."

 

<--- The logic is not so clear. Could you share some mock-up and show more details about you expected result and the current measure you are using?

 

Regards,

Jimmy Tao