Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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
Solved! Go to Solution.
Seems like you'd like to get the Distinct count, did you try this option?
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]))
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.
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.
thanks
Seems like you'd like to get the Distinct count, did you try this option?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |