Forum Discussion

elkjoperik's avatar
elkjoperik
Icon for Helper II rankHelper II
8 years ago

Like for Like filter based on YEAR

Hi, I have a report where I can  filter out on YEAR - MONTH - WEEK and DAY.    From 2015 and until now, we have opened many stores each year, so benchmarking 2018 vs 2017 will not be correct since...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi elkjoperik,

 

Could you post your table structures with some sample/mock data and the expected result, so that we can better assist on this issue? It's better to just share a dummy pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

 

Regards