Forum Discussion
RobRayborn
2 years agoHelper IV
Problems with Date Formats
I am having problems with a file of Excel worksheets. I have almost 11 months of data with one Excel file per workday. Within the worksheet I have a column of Dates. All of these are in this for...
- 2 years ago
Hi RobRayborn
Best way to fix it is directly into the source. Keep harrasing the creator to correctly format the whole field in excel better than wasting time in Power Query and DAX in Power BI.
aj1973
2 years agoCommunity Champion
Hi RobRayborn
Best way to fix it is directly into the source. Keep harrasing the creator to correctly format the whole field in excel better than wasting time in Power Query and DAX in Power BI.