Forum Discussion
Help Creating A New Table
Thanks for the reply, however displaying the data's not the issue. I'm able to filter the data to just show data from Sundays. what I want is to create a table that has a date column - taken from one of the exisiting tables so the start and end dates correspond - plus the two calculated columns. I'm fine with the calculations that need to go into the columns, I'm just not sure how to create the table.
when in data view, use the Modeling tab in the ribbon, select 'New Table'
this will open the formula bar just below the ribbon where you can define your new table i.e.
NewTable = Table1 [DateField]
and this will create that table for you.... if Table 1's date field has repeating dates and you want just unique dates then wrap this with VALUES ( )
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.