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 All,
I am struggling to put the below data into a Power BI, especially as the WK/Date values will change as time progresses...so the query will break once WK44 passes. It also is hard for me to get Power BI to recognise the WK values as dates (so I tried to create a relationship between them with my own WK -> Date chart) but I still dont think this has been effective.
ITEMS | WK44 | WK45 | WK46 | WK47 | WK48 |
| 31/10/22 | 07/11/22 | 14/11/22 | 21/11/22 | 28/11/22 |
Item A | 100 | 80 | 70 | 200 | 499 |
Item B | etc. | etc. | etc. | ||
Item C |
Any ideas on this please would be greatly appreciated.
@TotunG ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
refer if these can help
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
Appreciate your Kudos.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |