Forum Discussion
Date Format
Not sure how you're handling your dates or whether you're talking about implicit or explicit measures, so it's hard to say. Here are a few things that may help you:
- Apply a locale when you're ingesting date columns in Power Query. Typically you'd do this in your date dimension table.
- Use the FORMAT DAX formula to enforce exact date rendering:
- Use the column formatting options from the modelling view.
Not sure how you're handling your dates or whether you're talking about implicit or explicit measures, so it's hard to say. Here are a few things that may help you:
- Apply a locale when you're ingesting date columns in Power Query. Typically you'd do this in your date dimension table.
- Use the FORMAT DAX formula to enforce exact date rendering:
- Use the column formatting options from the modelling view.
The third option (Use the column formatting options from the modelling view) worked.
Thank you!
