Weekly Report ?

[suvechha]

Hi there,

My Date Table is 

Date =

ADDCOLUMNS (

CALENDAR (DATE(2020,1,1), DATE(2021,12,31)),

"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),

"Year", YEAR ( [Date] ),

"Monthnumber", FORMAT ( [Date], "MM" ),

"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),

"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),

"MonthNameShort", FORMAT ( [Date], "mmm" ),

"MonthNameLong", FORMAT ( [Date], "mmmm" ),

"DayOfWeekNumber", WEEKDAY ( [Date] ),

"DayOfWeek", FORMAT ( [Date], "dddd" ),

"DayOfWeekShort", FORMAT ( [Date], "ddd" ),

"Quarter", "Q" & FORMAT ( [Date], "Q" ),

"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" ),

"Week Start date" , [Date] + -1*WEEKDAY([Date],2)+1,

"Week End date" , [Date] + 7 -1*WEEKDAY([Date],2),

"Week Number" , WEEKNUM([Date],2),

"Weekday" , WEEKDAY([Date],2),

"WeekDay Name" , FORMAT([Date],"ddd"))

How to achieve the below charts without the creation on new group ?
Because when I created New Group , I was not able to create "Week Number" , WEEKNUM([Date],2) which is also required for some reports.

sample model link : https://1drv.ms/u/s!AhqwbtIVEKQ2bBzZ7PyqQ6ot-vk?e=Zu2E2b 

Thanks

[Greg_Deckler]

@suvechha - It's very hard to tell, are you looking for something like Open Tickets? - https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147

I downloaded the PBIX but I am not certain what you are trying to dispaly in that chart.

[suvechha]

Hi Greg,

My requirement is to create a line chart with measures as COUNT(WORKORDERID) and legend as STATUSNAME 

and Axis with Weekly 

The problem is how to show the Axis as in the image i.e

02Aug ,09 Aug , 16 Aug and 23 Aug .

I tried with New Group and it worked with 7 Days but when I want to add WEEKNUM in the New Group it was not working.

I want the below line chart and WEEKNUM function as well.

Hope this explain.

Thanks

[v-diye-msft · Accepted solution]

Hi @suvechha 

Do you mean you'd like to put the weeknumber as axis?

You can drag the week number column to the exist week start date column and generate the hierarchy. then put the hierarchy column as axis. Hence it;s able to drill down to the weeknumber:

[amitchandak]

@suvechha , You have week wise data when you create open , just like current employee in my blog and group it by week it will give week wise data

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Current Employees = CALCULATE(COUNTx(FILTER(Employee,Employee[Start Date]<=max('Date'[Date]) && (ISBLANK(Employee[End Date]) || Employee[End Date]>max('Date'[Date]))),(Employee[Employee Id ])),CROSSFILTER(Employee[Start Date],'Date'[Date],None))

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...