Forum Discussion
Advocate IIHow to create Blank query and Table in Power BI.............
Hi Pratima,
I think you can refer to below link to know how to use power query to create a table:
Creating Tables In Power BI/Power Query M Code Using #table()
Steps:
1. Click on "Editor Queries" to open the query editor.
2. Find out the "Queries" panel, right click on the blank place below the panel and choose "New Query" -> "Blank Query".
3. Refer to steps in above link to create the new table.
Regards,
Xiaoxin Sheng
Hi Pratima,
I think you can refer to below link to know how to use power query to create a table:
Creating Tables In Power BI/Power Query M Code Using #table()
Steps:
1. Click on "Editor Queries" to open the query editor.
2. Find out the "Queries" panel, right click on the blank place below the panel and choose "New Query" -> "Blank Query".
3. Refer to steps in above link to create the new table.
Regards,
Xiaoxin Sheng
What worked for me was saying New Table on the ribbon
Typing in the circled formula
& the results come through
In this instance I am working at getting a dsate table with unique dates from the original table
I find this is useful when I am plotting charts & I need fixed min and max dates that don't vary depending on the Category I am visualising