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,
Pleaase could i ask for your help
I am new to BI and need to create a report that shows a week by week count.
So the infomation is pulled in via an Access DB
The ImportDate will be used to create the week by week count
Start date would be a Saturday
End date would be a Friday
so the line chart should show - 29 -09 - 2017 / 06 - 10 - 2017 / 13 - 10 - 2017 (for the whole duration 2016/2017/2018)
then i would add the milestone stages, aligned end date, target qty
Seems like there is some information missing but I think I get the gist of it. What I would do would be to create a calculated column using the WEEKNUM function.
https://msdn.microsoft.com/en-us/library/ee634572.aspx
Then you could aggregate based upon the week number.
Please coul i ask for some more help, i am new to BI 🙂
This is what i am trying to achive
so the column that has a monday to friday update would be the ImportDate column or what a calendar column need to be added?
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |