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.
Hi,
I have integrated sharepoint list which has log entry and has following columns
S-NO
Created By
Company Name
Time In
Time Out
i want to calulate data like
Total records : 10
Company name have most entry : ABC Company
Created By have most entry : ABC Person
Please guide how can i calculate this.
Thx
Solved! Go to Solution.
Hi
How do you define “Company name have most entry”?
The company name which has most counts of rows in the column “Company name”?
Or, The company name which have the most time period between Time in and Time Out?
If situation1, I create measures to achieve results below
totalrecords = CALCULATE(COUNTROWS(Sheet1),ALL(Sheet1))
countpercompany = CALCULATE(COUNT(Sheet1[S-NO]),ALLEXCEPT(Sheet1,Sheet1[Company Name]))
rankofcount = RANKX(ALL(Sheet1),[countpercompany],,DESC)
Company name have most entry = IF([rankofcount]=1,[Company Name],BLANK())
countpercreatedby = CALCULATE(COUNT(Sheet1[S-NO]),ALLEXCEPT(Sheet1,Sheet1[Created By]))
rankofcount2 = RANKX(ALL(Sheet1),[countpercreatedby],,DESC)
created by have most entry = IF([rankofcount2]=1,MAX([Created By]),BLANK())
If situation2,
Create measures below to get Company name which has most entry
Measure1 = DATEDIFF(MAX([Time In]),MAX([Time Out]),MINUTE)
Measure2 = RANKX(ALL(Table1),[Measure1],,DESC)
Measure 3 = IF([Measure2]=1,MAX([Company Name]))
Best Regards
Maggie
thx for quires, but how i do it in Power Bi.
Hi,
now i got where to create measure. basically i want following result. pls guide which formula to use.
SNO | Company | |
1 | ABC | |
2 | RR | |
3 | FF | |
4 | ABC | |
5 | RR | |
6 | ABC | |
7 | FA | |
8 | XY | |
9 | ABC | |
10 | ABC | |
OutPut | Company Name | Count |
1 | ABC | 5 |
thx
It show multiple entry for company where i want to show one entry with just count.
Thx
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |