Skip to content
Advertisement

Tag: powerbi

Need help to build a sales funnel report by sql query

I have created a view for sales.In this view, there are relations among lead, opportunity and quotation. We can see not every lead turns to opportunity and quotation. LeadID OfferingID QuotationID Product Salesperson Department Date Salesprice My final output for the sales funnel for all department will be like [total number of leads (6)]->[total number of offering(5)]->[total number of quotations(3)].

How to combine rows with the same ID into a list

How can I make the below table like a list. I want the result to be like this Any ideas? Answer try the following, it may solve your problem. Let’s say your existing table name is yourTable and the new table to be created is groupedNames. in data view, click on new table and paste the following:

Possible to load .SQL file to Power bi?

Just started exploring power bi and I came across a basic question that I find difficult to get a correct solution. Is it possible to load .sql file in power bi and create a report for it? thanks Answer It is not possible to load a .SQL file in a Power BI report, but you can specify a SQL query

Advertisement