I have two tables which are as follows: Table1 and Table2. Table1 : Table2: I want a SQL query which would show me the result in total manner. The Output that I want is : I have done it using the PowerBI and I know it can be done using SQL too but I am not able to achieve it.
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)].
Is there a way in SQL or Power BI where I can define jobs and figure out the time it takes to do a job and then time in between jobs?
In the table below, there are job activities and unique identifiers under lodnum. I’m trying to figure out a way to get the time difference in between a job. A job such as pallet move has two entries. …
Sum and Count by month, shown with last day of that month
I have a transaction table like this: I need to sum amount and count transactions by year and month. I tried this: It works like charm. However, I will use this data on PowerBI thus I cannot show these results in a “line graphic” due to the year and month info being in separate columns. I tried changing format on
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:
SQL/PowerBI search in a particular line (not row) of data
I have a column with multiple line data. It shows as one line in SQL Server but multiple lines in Power BI so I guess there are some special characters in there to tell Power BI where the new line starts. What I want to achieve is to search the second to the last line instead the whole cell, to
bad date format for pivot
together I can not figure out why in PowerPivot or Excel a Microsoft query does not provide the date fields in the format for Excel as they are necessary. I have already gotten from you in another …
Is Power BI Best Practice to Group Data in the SQL Query Before Importing even though this may effect how you write some DAX expressions later?
I’m importing data via SQL import to a Power BI data model. If I group the data I can save the import 100,000 rows, but it effect the way I write my DAX queries to get the correct answer (and makes them slightly more complex). I’m after the general best practice for where to group data, pre import, or post
Use time selector from Power BI as an argument in my SQL query
I have a simple query like : SELECT COUNT(DISTINCT(p.id_organization)) AS Count FROM dbo.paiement p WHERE p.statut = ‘AUTHORIZED’ AND p.[date] > ‘2018-01-30’ I try to show this data on a …
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