Creating data sets for future steps

[mitchellj]

I've used other drag and drop query tools, and appreciate those that allow you to query data to create a table, and then run other queries on those new tables.  As I investigate Power BI, is it safe to say that I'll be able to use that same methodology, using multiple steps and tables to get to an outcome?

Thanks.  I know this is a softball of a question, but I was hoping to get this basic question answered before I dive into Power BI.

[mitchellj]

x

[mitchellj]

Test

[mitchellj]

Just testing to see if I can get past the "invalid HTML" message that is keeping me from reply to those answering my question...

[Fowmy]

@mitchellj 

With Power BI, you build the data model and use DAX language to query the data using Calculated Tables or Measures. When you create visuals based on these table fields and measures, it sends queries to the data model to fetch data.

If you need to query the data as you do in other tools and your purpose is to see the data as summaries then, better use DAX Studio which can be installed then added to your external tool tab. It provides rich querying and optimizing capabilities.

https://daxstudio.org/

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn