try to explain by excel, my table only have few item of event in a peroid of time,
then I would create an autocalendar and countif event on happen on this calender
=COUNTIFS(Sheet1!$D$2:$D$5,"<"&A2, Sheet1!$E$2:$E$5,">"&A2, Sheet1!$C$2:$C$5,"=TW")
How to do it by power BI, if i do it in excel the detail in power BI cannot interact
/* old message
how to count for event in a peroid of time
if i have 4 excel for different supplier
each have 3 to 6 events in last year
then i have 350 item in my date table as prefer
and 1 only have 15 item total form all of my excel, and all event have open and close date
we only count event between open and close
how can i count for the opened event with the 350 days auto date?
not the trend for every date
Solved! Go to Solution.
I just found this method will lost interact with the source table.
once i try to filter the event type, there still count for all, and can't find away to solve it yeah
sorry i am confused for now -7 and now-2 means,
is this better to use Los Angeles, CA, USA TIME 19:30, and this will be 10:30 in my time zone,
so what is your prefer time period in LA time???