Change text date to a date type

Since your values are text in DDMMYYYY format, Power BI won’t auto-detect them as dates. You need to explicitly parse them.

Do this in Power Query, not DAX.

1. Select the column

2. Transform → Extract → Text Range

   • Day: start 0, length 2

   • Month: start 2, length 2

   • Year: start 4, length 4

3. Add a Custom Column:

= #date(
    Number.FromText([Year]),
    Number.FromText([Month]),
    Number.FromText([Day])
)

• Set the new column’s type to Date

• Remove the original text column if needed