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???
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.