Need PowerBI Graph to COUNT Open Tickets over a certain TIME period

[Anonymous]

Hi!

I am needing for PowerBI to chart out tickets that were created in Dyanmics over a certain time period.

I only need to see how many tickets were created/opened across an entire month and fall within the following time windows:

Monday-Friday (each day) 6pm-6am Pacific

Friday 6pm until Monday 6am

Is this possible? If so, how do I achieve this? I am a pretty beginner at Power BI and I have created some cool charts and graphs, but I am not good at coding a request. 

Thanks!

[v-lionel-msft]

Hi @Anonymous ,

Has your prblem been solved? If not, please show me a sample data.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

If your date table create at date and time with 6 PM

Monday of this week is

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

Next week is

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1 +7

Friday of my week start

Week Start date = 'Date'[Date]+-1*if(WEEKDAY('Date'[Date])-6<0,WEEKDAY('Date'[Date])+1,WEEKDAY('Date'[Date])-6)

Using + or - 7 to these formula create Friday and Monday with time and then use that as filter in you table