Forum Discussion
Solved
Power BI error BUG with date
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 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])
When transforming the data type to "text" I get it right, but I do want to use the "date" type.