Question on DataMart

I'm using Dataflows as a source for my datamart. Is there a way to create a new table using the view that gets generated as a result of an SQL query? For example- I'm merging two tables using an SQL query inside my datamart, is it possible to store this new merged table as a table in my datamart?

If not, what could be a possible solution to this? I could only think of converting the SQL code to M code and creating a new table, or using a dataflow to create the table I want and use it in the datamart directly as a source.

Thanks in advance! 🙂