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???
Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.
This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.