For some reason my app randomly puts in the wrong date format into the Excel that ends up messing up a few caluclations in the app itself.
I even got to the point where I put my input format on the app to:
And it works and puts the date as 11-29-2017 but then randomly it starts puting the date into Excel as 2017-11-29T06:00:00.000Z
Is your excel sheet for that column has a different date/time format? Would you mind checking to ensure, the column of the excel itself is not enforicing another format?
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand