Forum Discussion
Help Creating A New Table
Thanks CahabaData, I tried your suggestion but got an error message - "A single value for column 'date' in table 'Facebook - key metrics' cannot be determined. this can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count or sum to get a single result.' I wrapped the the syntax in 'All ()' and it worked except that it added an extra row to the end of the table that was blank. Do you know why this would be or how I can get rid of it? It causes problems when I add the calculated columns.
I wonder about that error message in that it seems oriented to a measure; and my intention was a new calculated table.
In regard to a blank row in a table; yes that can be dealt with in the Home tab up in the ribbon; with the Query Editor; in that window's ribbon is a Remove Rows option.