I'm loading a CSV datafile into Power BI web version that includes a date field in the format and data like this:
This results in Power BI creating some additional columns for Month, Year, and day that greatly help in summarizing the data.
When I load the same CSV file into Power BI Desktop, it does NOT create the additional columns of helpful data.
Is there a way to tell Power BI Desktop to do this, or create the same manually? Am I missing some critical piece of date formatting documentation?