Forum Discussion
Date column not modeling correctly
I have a column for invoiced_date that was already transformed to a date type in power query, but is not showing that it is a date column and because of that it isn't modeling correctly? What could c...
vonw13
Please check in Power query if the INVOICE_DATE column has errors. With out enough details, it's hard to suggest a solution.
No errors and no blanks, what other details would be helpful?
The total in measure 2 is correct when using the invoiced date within the same table, but doesn't do mtd when using the calendar table.