Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
Currently I am working on a project with power BI where I have to show week over week comparison of some data for a particular month.
The users upload the file once every week with a create date on sharepoint I need to show comparisons between different week of month .
Also if data stored is from Jan-June users can filter the records by month to see all four week of January and June.
Data -:
pattern status. Datecreated
ADFS. Production. 04/02/2020
FMSSO. In pipeline. 04/02/2020
::
ADFS. Production. 05/02/2020
FMSSO. In pipeline. 05/02/2020
Solved! Go to Solution.
@Anonymous , Refer my blog on Week:
@Anonymous , Refer my blog on Week:
Thanks everyone but I am still not getting it.
I did created the date table based on above blog post but how can I show all the week total in a given month.
I want something like in a given month we have four weeks
so it should show
Week1 Week 2 Week 3 Week 4
20 30 23 30
Show me a single month in the last ten years that had 4 weeks.
Weeks in a month? Do you have a dates/calendar table that clearly spells out which week every single day is in? "four weeks in a month" is only true for February if it is not a leap year and february 1st falls on a day that you identify as the start of the week. Meaning this happens extremely rarely.
User | Count |
---|---|
127 | |
108 | |
100 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |