cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChristianVMT
New Member

Count days of use of an application

Hello,
The number of days between dates I am referring to is as follows:
The following table records the date when a user opens a Word document in this case.

 

ChristianVMT_0-1602284870576.png

 

I would need to add a column indicating the days the "Word" application was used. For example, with the filter of dates from 09/01/2020 to 09/30/2020, in that month the user only has documents open on 3, 5 and 28, in this case in the third column it must indicate 3 days.

ChristianVMT_1-1602285170844.png

 

I've been thinking over and over again and I haven't been able to know where to start, I hope you can give me some idea.

Thank you

1 ACCEPTED SOLUTION

Hi @ChristianVMT 

 

Seems like you'd like to get the Distinct count, did you try this option?

3.PNG

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

3 REPLIES 3
pranit828
Super User
Super User

Hi @ChristianVMT 

your sample input and ourput doesn't match.

Sample your input in a small set and provide desired output for that particular input.

From what I could understand, Please try the below code.

Calculate(distinctcount('table'[nom_users]), ALLEXCEPT('table','table'[File]))




PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

Hello @pranit828 ,
The apologies for not giving me to understand, I will try to be more precise:
The following image shows how the data is approximately.

ChristianVMT_0-1602510661586.png

in this other image is the result, which tells us that AMENCISOV got to use the software "Word" in three days (10, 11 and 14) and "APACHASP" only one day (21). I think that the result should be given in a new table "CALCULATETABLE" and that as a calculated column I don't see that it is possible.

ChristianVMT_1-1602510782108.png

thanks

Hi @ChristianVMT 

 

Seems like you'd like to get the Distinct count, did you try this option?

3.PNG

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!