Forum Discussion
Day wise comparison with previous year
Hi guys i am facing a problem, i want to comapare week-days with previous year i.e Eg: sunday to a sunday and monday to a monday and assign the comparable days as 'X' and non compoarable days as 'Y'....
Anonymous
Try this solution!
https://www.dropbox.com/s/lvy5s1mbc3nsnic/Day%20wise%20comparison%20with%20previous%20year.pbix?dl=0
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be Datanaut!
Sry Anonymous i could not able to access the link. i could not open it.
- tex628
Community Champion
Create a key in your datetable using YEAR(), WEEK() & WEEKDAY()
Then match 18-49-1 with 19-49-1 etc.
