Forum Discussion
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 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.
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])
2 Replies
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.
