Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I know there are some other post here but reviewing them I am still having issues getitng my data to format correctly.
I am trying to take this formula and get it to work in power bi: =COUNTIF(ProjectInfo!B:B,ProjectInfoCount!B1)
Any help would be greatly appriciated. If i figure out an answer I'll post it.
Thanks!
~Chris
Solved! Go to Solution.
Hi @Anonymous,
Would like something like below? Please download the demo from the attachment?
Best Regards,
Hi @Anonymous,
Could you please mark the proper answers as solutions?
Best Regards,
Sorry I was going to get to it but have been tied up.
Hi,
Share some data and show the expected result. I should be able to paste your data in an Excel file.
Thanks! Here's the expected result in Excel and some data!
Hi,
I cannot do anything with this. I need data in a format which i can paste in an Excel file.
Sorry for miss understanding, didn't realize pasting data would come into a useable format!
Proj Info PD | Proj Info SD | Proj Info DD | Proj Info CD | Proj Info CA | Base Number |
- | - | - | - | - | 002002 |
- | - | - | - | - | 002014 |
- | - | - | - | - | 003026 |
- | - | - | - | - | 003043 |
- | - | - | - | - | 003043 |
- | - | - | - | - | 003043 |
- | - | - | - | - | 003060 |
- | - | - | - | - | 003060 |
- | - | - | - | - | 003112 |
- | - | - | - | - | 003112 |
- | - | - | - | - | 003112 |
No | No | No | No | No | 003113 |
- | - | - | - | - | 003113 |
- | - | - | - | - | 003113 |
No | No | No | No | No | 003113 |
No | No | No | No | No | 003113 |
No | No | No | No | No | 003113 |
- | - | - | - | - | 003113 |
- | - | - | - | - | 003140 |
- | - | - | - | - | 003140 |
- | - | - | - | - | 003140 |
Yes | Yes | Yes | Yes | Yes | 003140 |
Yes | Yes | Yes | Yes | Yes | 003140 |
Yes | Yes | Yes | Yes | Yes | 003140 |
- | - | - | - | - | 003140 |
Yes | Yes | Yes | Yes | Yes | 003140 |
- | - | - | - | - | 003434 |
- | - | - | - | - | 003434 |
No | No | No | No | Yes | 003449 |
- | - | - | - | - | 003449 |
- | - | - | - | - | 003449 |
- | - | - | - | - | 003449 |
No | No | No | No | No | 003526 |
No | No | No | No | No | 003526 |
- | - | - | - | - | 003569 |
- | - | - | - | - | 003569 |
- | - | - | - | - | 003569 |
- | - | - | - | - | 003569 |
- | - | - | - | - | 003569 |
- | - | - | - | - | 003640 |
- | - | - | - | - | 003640 |
- | - | - | - | - | 003640 |
Hi,
I am not clear about your expected result - from your initial post, your expected output is not clear.
Thanks! Here's the expected result in Excel and some data!
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |