Forum Discussion
Solved
Identify last day
Hi guys, I have a date table being constructed like: Date = ADDCOLUMNS ( CALENDAR (DATE(2017;5;1); TODAY()); "DateAsInteger"; FORMAT ( [Date]; "YYYYMMDD" ); "Year"; YEAR ( [Date] ); "Mon...
Vvelarde i'm trying to resolve on the Stores table with M function. Any idea how to solde the error:
Expression.Error: Não é possível converter o valor #date(2017, 8, 8) para o tipo List.
Detalhes:
Value=08/08/2017
Type=Type
if [Date] = List.Max([Date]) && [OS] = "Android" then 1 else 0