I HAVE CREATED A TABLE USING DAX BUT UNABLE TO FIND IT WHEN USE EDIT QUERIES

[Kasunpathirana]

I have created a table using DAX but when try to use EDIT QUERIES I'm not seen this table under queries section. I need to use this table to create a join and create another table.

Is there a workaround or is there anything which i missed?

[Parihar1980]

You can Join table using Related funcation in Power BI. 

https://msdn.microsoft.com/en-us/library/ee634202.aspx?f=255&MSPPError=-2147217396

http://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/

[Kasunpathirana]

I have tried the above suggestions. My issue is I have a calculated column using DAX this calculation involves two tables. Then once i create this field then Require to Summarize into a table. Once I summarize using the DAX query the new summarized table is not able to use in the EDIT QUERIES.

How should I enable summarize table for EDIT QUERIES?

[v-ljerr-msft]

Hi @Kasunpathirana,

Could you post your table structures with some sample/mock data and your expected result, so that we can further assist on this issue? It's better to share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards

[Kasunpathirana]

There is two Tables Price and Quantity is coming from SQL Tables and Total-Manual is csv file need to combine all the sales result. When create summary table then as shown in 3rd picture unable to see the summary table in the edit queries.

What will be the best method to acheive above expected result. 

[v-ljerr-msft · Accepted solution]

Hi @Kasunpathirana,

According to your description above, you should be able simply use the formula(DAX) below to create a new calculate column in the Total-Manual table without combining all the sales result in Query Editor in your scenario. 

Total Sales 2 = 
IF (
    ISBLANK ( 'Total-Manual'[Total Sales] ),
    CALCULATE ( SUM ( Quantity[Total Sales] ) ),
    'Total-Manual'[Total Sales]
)

Note: make sure you have created a relationship between the Quantity table and the Total-Manual table with Company column.

Regards

[Kasunpathirana]

Great it really works @v-ljerr-msft thanks for the quick support

[vanessafvg]

@Kasunpathirana if you want the table in power query i think you need to create it in power query not dax.

however you can join this table in your relationships view, have you tried that?