Forum Discussion
Helper VTable and column
waleed111 , Because selectcolumns return table. And when you create a new column it expects a new column value only one unique value. So new table it works and New columns it gives an error
https://docs.microsoft.com/en-us/dax/selectcolumns-function-dax
https://www.youtube.com/watch?v=TtkdZ2jbffA
New table is working because it expects a table
table = SELECTCOLUMNS('List View', "inventory", 'List View'[Date-Time of Entry in Inventory])
This function can now return a new column
Column = maxx(SELECTCOLUMNS('List View', "inventory", 'List View'[Date-Time of Entry in Inventory]),[Date-Time of Entry in Inventory])
Super Userwaleed111 , Because selectcolumns return table. And when you create a new column it expects a new column value only one unique value. So new table it works and New columns it gives an error
https://docs.microsoft.com/en-us/dax/selectcolumns-function-dax
https://www.youtube.com/watch?v=TtkdZ2jbffA
New table is working because it expects a table
table = SELECTCOLUMNS('List View', "inventory", 'List View'[Date-Time of Entry in Inventory])
This function can now return a new column
Column = maxx(SELECTCOLUMNS('List View', "inventory", 'List View'[Date-Time of Entry in Inventory]),[Date-Time of Entry in Inventory])