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 all,
can you please give a hint on the following:
My XLSX-source file contains, amongst other columns ,two columns representing "from" and "until"- information.
Unfortunately the way of entering data is not governed, so there is a mix of real date-entries (e.g. "19.10.2021") and text-like-entries (e.g. "October 2021"). the columns are recognised in PQ as alphanumeric (123/abc).
I want to work on these cases in PQ, but I do not find a keyword to search with ("data entered by unexpierienced users" isn't a suitable ...).
Can you please provide a link to a tutorial or sth similars or even better a source where problems of these kind are handled?
thank you in advance
Thomas
Solved! Go to Solution.
I put your two values in and converted it to a Date column (click on the abc123 and choose Date), and it worked. Have you tried that already? When you do that, any that don't work will show as "Error". Please share those values (click to the right of the word Error to see the original value below the preview), to get specific suggestions.
For now, I would work toward improving the data validation on your source, if possible.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi mahoneypa,
thank you for this suggestion, it worked perfectly
(Note to myself: Being more "experimental" helps!)
Nevertheless the way of data-maintenance and -governance is still to discuss with responsible departments...
Once againt
hank you very much!
Thomas
I put your two values in and converted it to a Date column (click on the abc123 and choose Date), and it worked. Have you tried that already? When you do that, any that don't work will show as "Error". Please share those values (click to the right of the word Error to see the original value below the preview), to get specific suggestions.
For now, I would work toward improving the data validation on your source, if possible.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi mahoneypa,
thank you for this suggestion, it worked perfectly
(Note to myself: Being more "experimental" helps!)
Nevertheless the way of data-maintenance and -governance is still to discuss with responsible departments...
Once againt
hank you very much!
Thomas
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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |