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???
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
We had a great 2022 with a ton of feature releases to help you drive a data culture.