Forum Discussion
Unable to Convert list output to Date type
If the [Min Date] and [Max Date] columns in that table are Date type then the List.Min should return a Date (and it appears to do so in your pic). Are they Date type? If so, where is that date used and what is the error message for that table/query?
Pat
Hi Pat,
The [Min Date] and [Max Date] are not columns they are the output of blank queries with this formula/m code:
[Min Date]
[Max Date]
These 2 queries are fed into this date table:
I convert this list to a table ofcourse and then once I exit the query to go to power bi desktop home page I get the error as I posted above.
The FilterOutUnnecessaryColumns[Min Date] is a column reference that returns a list, and List.Combine is putting those two lists together for List.Min. Also, the pic with the error is only showing that there was an error with another query (not shown in pic), there may not be an issue with the Min Date and Max Date queries. Which query actually had the error?
Pat
This is the error:
The date table has no errors:
Your Min and Max queries are sourced by the FilterOutUnnecessaryColumns query. Does that have data? To isolate the issue, you could hard code a list of dates to your min and max queries to see if it is the Date Table or FilterOut query that has the issue.
{#date(2021,1,1), #date(2021,6,1)} // example list of dates
Pat