Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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'. How can i comapare it. is there any solution Please help me with it.
@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.
Create a key in your datetable using YEAR(), WEEK() & WEEKDAY()
Then match 18-49-1 with 19-49-1 etc.
What I would do is take the WEEKDAY(FIRSTDATE(DATE columns)) for each of the date columns you have. Then I would subtract these two values, for the sake of example let's call it X. This X value will be the transformation constant we'll use to adjust the day of year column. Then I'd create a new column called index in the older table such that INDEX = DAYNUM(DATE (older columns)) - X. Then connect this column and your other day of year column. I'd connect them both to a dates table.
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |