Date format issues

amitchandak thanks for the quick response. This was indeed the case, no matter if from CSV in mm/dd/yyyy format or from excel in dd-mmm-yyyy format, in PowerBI Desktop they all showed as dd/mm/yyyy format based on my system (regional settings), without me touching anything.

However when published, some of them (the ones originating from Excel sheet and my calculated columns) displayed in mm/dd/yyyy while the ones originating from the CSV files showed as dd/mm/yyyy in the service.

Reading through various posts in this community I didn't get any closer to a solution, but now I realized that in this field

You're not limited to what is available in the list. Which makes me think that a lot of people don't know this either, as in may posts they state that they can't select what they need.

But as a matter of fact, you can just type the desired format string in the box!

Even though Events[End Date] is a date column, the calculated column does not inherit that property, it is of type text and displays the data as it's stored (mm/dd/yyyy) rather than how it is displayed in the date column.