I have faced a problem in PBI.is there any soloution that a summarized table created by DAX formula bring in query editor.Seems that only the source tables can be seen in query editor?
Correct. You would have to create a new query and do your summarize in the query editor instead.
Proud to be a Datanaut!
You should download the DAX Studio. Connect Your PBI File with DAX Studio and Run your DAX Query againest the Model and set the output to the Text File. This File will have your Summerized table Data and You can ETL with this data into the PBI.
Not like tables(queries) created in Query Editor can be shown and referenced in Data View of Power BI Desktop, the calculated tables created in Data View using DAX can only be used within Data View.