Forum Discussion
BigLo
5 years agoHelper III
count active elements items between 2 dates
Hello, I want to count the number of active elements between 2 dates. I have their activity start date and their activity end date. My goal is to make a line graph with the number of active elem...
- Anonymous5 years ago
Hi BigLo ,
I'm so sorry that I made a mistake on the formula of measure. Is there anything else about this thread need help from my side? If it is all ok now, could you please mark it Answered now? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.
Best Regards
Pragati11
5 years agoSuper User
Hi BigLo ,
Few questions:
- what is the definition of ACTIVE elements between 2 dates? you haven't mentioned it.
- The screesnhot of the data doesn't help us if we want to try it at our end. Please attach sample data as a file attachment so that it can easily be imported to Power BI.
Thanks,
Pragati
- BigLo5 years agoHelper III
Thanks,
Here is the file https://1drv.ms/x/s!AnCIbCo-paOMh0xCJDd-hfe73cfL?e=EHTCoO
an item is active on the start date until the end date.
For example: the active start of id 1 is 2021-02-01 and its active end is 2022-07-03.