sometimes small and obviously simple tasks, drives you crazy. And this is one, which is desperately required to provide professional reports. Hope you can help me with the following:
I would like to display the last date when an Excel-File has been modified in a “Card”. Some other dates from the content of the Excel-File should be displayed in a table.
Unfortunately the ‘Modified Date’ is in “en-us”-format (mm.dd.yyyy) and the dates in the content are in date-format “german” (dd.mm.yyyy)
As PowerBI only allows to set the locale for the complete file, one of the dates always invokes an error .
Even after having unchecked the automatic “type detection” in the options, I was not able to convert the date manually.
If I could provide a locale for each query, I could define 2 queries. The first will load the “Date Accessed” with the locale “en-us” and the second will load the dates from the content with the locale “german”.
Any idea on how to solve this or any other idea is highly appreciated.
Thanks in advance for your support.