Top "Powerbi" questions

Power BI is a free, self-service analytics tool available individually or integrated with Microsoft Excel, Office 365 and all major Databases and analytics tools.

Difference between PowerPivot, PowerQuery and PowerBI

What is the difference between PowerPivot, PowerQuery and PowerBI? How should one decided which tool should be used and when.

powerpivot powerquery powerbi
how to convert a Integer to Text value in Power BI

I am creating a calculated column in existing power BI report. the calculated column concatenates integer & text columns. I …

sql powerbi dax m
How to format new measure (not column) in power BI as percentage?

When I create a new measure with formula, i.e. sum(col1)/max(col2), it automatically converts the result into #.#% …

powerbi dax
How to get month name from month number in Power BI?

I have Year number and Month Number in my data. How using DAX can I get the month name out …

business-intelligence powerbi dax
Count and group by Power BI

I am beginner at Power BI and I'm trying to group my data by "Opp title" and count the number …

group-by count powerbi
Multiple IF Statements in DAX

I currently have Column Data formulated below in Power BI which I need for it to display in one column …

if-statement powerbi dax
Using Multiple filters in DAX

I'm new to DAX. I'm currently using Power BI and trying to create a total sum of sales that use …

excel pivot dax powerbi
Power BI, DAX--How do I count rows in one table based on values in another table?

I have two tables, lets call them Table1 and Table2. Table1 has a column of unique values, Table2 has a …

count powerbi dax
How to use SQL Server stored procedures in Microsoft PowerBI?

I want to generate reports from my SQL Server tables. I have some already made stored procedures that I would …

sql sql-server stored-procedures business-intelligence powerbi
Match and Get the Value from another table (Vlookup)

I have 2 tables connected to each other through col A. I want to match the column C with Col A …

powerbi match dax vlookup