Forum Discussion

EPJones's avatar
EPJones
New Member
2 years ago

Text Field Counted Twice

I have a fairly simple excel spreadsheet but it's pretty long. I'm trying to visually represent how many trips per day for manpower reasons, and it counts all instances twice, I can't figure out why....
Need Help
EPJones's avatar
EPJones
New Member
2 years ago

I could indeed just do a pivot table, but I'm asked to plop this into PBI, hence why I'm fighting with it. I'll just go ahead and re-import as a csv, I haen't tried that yet, maybe it'll remove whatever odd thing is causing PBI to count everything twice.

Thank you for looking at my question, I really appreciate it!

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

so it's a data importing issue? pls provide the original file.

  • EPJones's avatar
    EPJones
    New Member
    2 years ago

    I figured it out, thank you! Turned out my original data was corrupted somehow, and it reported twice. Thank you!