Forum Discussion
Text Field Counted Twice
what's the expected output based on the sample data you provided?
Ah yes, my apologies!
This is what I want:
January 1 - 8trips missed due to manpower
- 1 trip missed due to mechanical/engine
- 1 trip missed due to other
This is what I currently get, it double counts everything:
January 1 - 16 trips missed due to manpower
- 2 trips missed due to mechanical/engine
- 2 trips missed due to other
I'm looking for a graph that will show how many trips were missed due to manpower (in particular, others too) each day YTD.
don't know why what you get is counting twict.
i think you don't even need to create dax
pls see the attachment below
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!
so it's a data importing issue? pls provide the original file.
Hi,
Check the steps in the Query Editor. In the second/third step, then number of rows should be equal to the number of files lying in the folder from there you are importing data.
