Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |