Power BI error BUG with date

[vanetti]

I have a column for day, another for month and another one for year.

I´ve created a new column, merging DAY & "/" & MONTH & "/" & YEAR, but sometimes I get the format DD/MM/YY, sometimes MM/DD/YY.

I belive this is an error that need to be fixed. I had a really hard time to understand why my report had wrong data in it.

[KHorseman · Accepted solution]

I think it's because you're forcing it to parse a concatenated string as a date. It would probably be more reliable to use a DATE() formula, which explicitly tells it which number is the month and which is the day.

Dat formatada fat = DATE(CV_BILLINGLOGGSB[ANO_FATURAMENTO], CV_BILLINGLOGGSB[Mês da fatura], CVBILLINLOGGSB[Dia])

[vanetti]

When transforming the data type to "text" I get it right, but I do want to use the "date" type.