Trending questions in Power BI

0 votes
1 answer

To calculate conditional running total in power query

Try Table Buffer after adding the index, or ...READ MORE

Apr 26, 2019 in Power BI by Shubham
 • 13,490 points • 2,353 views
0 votes
1 answer

count of string in pie chart

Hi Prakash, Select the measure and measure that ...READ MORE

May 7, 2019 in Power BI by Cherukuri
 • 33,050 points • 1,768 views
0 votes
1 answer

Cumulative row data over last 12 months in Power Query

Basically, what you do is,  Add an Index,  Group ...READ MORE

Apr 1, 2019 in Power BI by Upasana
 • 8,620 points • 3,312 views
0 votes
1 answer

How to add slicer from a different tables?

Hi, Join is normally performed to get ...READ MORE

Mar 1, 2019 in Power BI by Cherukuri
 • 33,050 points • 4,616 views
0 votes
1 answer

How do you add a new column with the calculated result?

Hi, You can do this with the help ...READ MORE

May 27, 2019 in Power BI by Avantika
 • 1,520 points • 831 views
0 votes
1 answer

How do you schedule Data Refresh in Power BI?

Hi, Following could be the reasons why this ...READ MORE

May 21, 2019 in Power BI by Avantika
 • 1,520 points • 1,068 views
0 votes
0 answers

How do you create a relationship between two queries with same database?

I have some database view with several ...READ MORE

May 28, 2019 in Power BI by Phalguni
 • 1,020 points • 793 views
0 votes
1 answer

How to show sub total to sub groups along with individual values?

Hi Lassya, Follow the below steps: 1. Right click ...READ MORE

May 21, 2019 in Power BI by anonymous
 • 33,050 points • 981 views
0 votes
1 answer

Looping in Power Query

In Power Query, you often find a ...READ MORE

Jan 30, 2019 in Power BI by Upasana
 • 8,620 points • 5,759 views
0 votes
1 answer

How do I add a filter and a slicer?

Hi, Its OLTP and DW modeling. However, you ...READ MORE

May 23, 2019 in Power BI by Avantika
 • 1,520 points
edited May 23, 2019 by Omkar • 904 views
0 votes
1 answer

Use Measure/ column to replace text

Hi Nithin, For example, to replace null or ...READ MORE

May 17, 2019 in Power BI by Cherukuri
 • 33,050 points • 1,078 views
+1 vote
1 answer

Why doesn't the KPI refreshes in Power BI?

You would have to most probably change the ...READ MORE

May 15, 2019 in Power BI by Avantika
 • 1,520 points
edited May 15, 2019 by Omkar • 1,129 views
0 votes
1 answer

Replace and Round

Hey Anshuli, Create a column as below, Column = ...READ MORE

May 21, 2019 in Power BI by anonymous
 • 33,050 points • 729 views
0 votes
1 answer

End with characters in column

Hi Rahul, You can use condition such as ...READ MORE

May 21, 2019 in Power BI by anonymous
 • 33,050 points • 719 views
0 votes
1 answer

Starts with characters in column

Hi Rahul, You can use condition such as ...READ MORE

May 21, 2019 in Power BI by anonymous
 • 33,050 points • 676 views
0 votes
0 answers

Max rank among set of sub category

How to show the maximum rank under ...READ MORE

May 17, 2019 in Power BI by radha
 • 880 views
0 votes
1 answer

Power BI Embedded: DMTS_DatasourceHasNoCredentialError

You'll need to call the PATCH data source API Patch Gateway ...READ MORE

Apr 10, 2019 in Power BI by Shubham
 • 13,490 points • 2,430 views
0 votes
1 answer

Calculate and filter function - DAX

Hi Praneeth, Calculate () by default perform calculations ...READ MORE

May 2, 2019 in Power BI by Cherukuri
 • 33,050 points • 1,453 views
0 votes
1 answer

Conditional Formatting - Power BI

Hi Priya, Create a parameter and add it ...READ MORE

May 9, 2019 in Power BI by anonymous
 • 33,050 points • 1,136 views
0 votes
1 answer

Can i show data for one variable for a field without using slicer?

Hi Pranav, Yes, you can perform the calculation ...READ MORE

May 16, 2019 in Power BI by Cherukuri
 • 33,050 points • 765 views
0 votes
1 answer

Total sales for orders till current date using MTD

Hi Riya, Use the below code to find ...READ MORE

May 2, 2019 in Power BI by Cherukuri
 • 33,050 points • 1,333 views
0 votes
1 answer

how can I connect my web api with Power BI Reports?

Go to Home > Edit Queries > ...READ MORE

Oct 18, 2018 in Power BI by Annie97
 • 2,160 points • 9,799 views
0 votes
1 answer

Measure to filter date from another field

Hi, Create a column with [date-field].[month] to fetch ...READ MORE

May 17, 2019 in Power BI by Cherukuri
 • 33,050 points • 639 views
0 votes
0 answers

Average of 3 Months

hi, how to calculate the average for ...READ MORE

May 20, 2019 in Power BI by sindhu
 • 474 views
0 votes
1 answer

Why does a reference to a value in previous row throw this Expression.Error?

If you have multiple steps after the ...READ MORE

May 9, 2019 in Power BI by Avantika
 • 1,520 points • 925 views
0 votes
1 answer

Power BI : npgsql installation

As a general rule Npgsql can be ...READ MORE

Nov 27, 2018 in Power BI by Shubham
 • 13,490 points • 7,925 views
0 votes
1 answer

Power BI : Status Count

Try COUNT, COUNTX, or COUNTROWS . READ MORE

Apr 26, 2019 in Power BI by Shubham
 • 13,490 points • 1,443 views
0 votes
1 answer

How do I create a line chart?

Hi, From the data mentioned above, you can ...READ MORE

May 10, 2019 in Power BI by Avantika
 • 1,520 points • 832 views
0 votes
1 answer

Calling Azure API using Power BI with Next Link

Try this let iterations = ...READ MORE

Apr 9, 2019 in Power BI by Shubham
 • 13,490 points • 2,154 views
0 votes
1 answer

How do you change the tables in chart filters?

Hi, You can use the following measure. Measure 2 = ...READ MORE

May 10, 2019 in Power BI by Avantika
 • 1,520 points • 726 views
0 votes
1 answer

Count - using If within period of dates.

Hi Sindhu, Use below DAX code to create ...READ MORE

May 8, 2019 in Power BI by Cherukuri
 • 33,050 points • 802 views
0 votes
1 answer

Rank - Power BI

Hi Anitha, Drop Category, product-id, and sales into ...READ MORE

May 2, 2019 in Power BI by Cherukuri
 • 33,050 points • 1,026 views
0 votes
0 answers

How do you change the tables in chart filters?

I am working on a report that shows ...READ MORE

May 10, 2019 in Power BI by anonymous
 • 724 views
0 votes
1 answer

calculation with condition and filter

Hi Preethi, Follow the below steps: 1. Create a ...READ MORE

May 2, 2019 in Power BI by Cherukuri
 • 33,050 points • 1,000 views
0 votes
1 answer

Difference between the number of days user(client) has logged into the website.

Hi Rajesh, Use below code -  Column 4 = ...READ MORE

May 9, 2019 in Power BI by Cherukuri
 • 33,050 points • 672 views
0 votes
1 answer

append a column to another column

Hi Priya, You can use concatenate to join ...READ MORE

May 8, 2019 in Power BI by Cherukuri
 • 33,050 points • 692 views
0 votes
1 answer

conditional formatting - color to show few rows from acndition

Hi Priya, Create a matrix with region and ...READ MORE

May 7, 2019 in Power BI by Cherukuri
 • 33,050 points • 671 views
0 votes
1 answer

Text into URL

Hi Riya, To convert a URL or hyperlink text ...READ MORE

May 9, 2019 in Power BI by Cherukuri
 • 33,050 points • 572 views
0 votes
1 answer

dates in power bi

Hi Raju, You can show visual for a ...READ MORE

May 7, 2019 in Power BI by Cherukuri
 • 33,050 points • 598 views
0 votes
1 answer

Most recent order sales from customers

Hi Nithin, You can use LASTDATE() to fetch ...READ MORE

May 2, 2019 in Power BI by Cherukuri
 • 33,050 points • 798 views
0 votes
1 answer

Calculated column with the sum of values from many columns in a row

Hi, You can create a new column by ...READ MORE

Mar 14, 2019 in Power BI by Cherukuri
 • 33,050 points • 2,850 views
0 votes
1 answer

Top N - Power BI

Hi Priya, You can use Rank () or ...READ MORE

May 2, 2019 in Power BI by Cherukuri
 • 33,050 points • 647 views
0 votes
1 answer

How can I concatenate grouped values in PowerQuery ?

If your table is Source, and if ...READ MORE

Feb 27, 2019 in Power BI by Shubham
 • 13,490 points • 3,387 views
0 votes
1 answer

Adding values of two columns in two tables

Hi Anshuli, You can either create a separate ...READ MORE

Apr 10, 2019 in Power BI by Cherukuri
 • 33,050 points • 1,548 views
0 votes
1 answer

Power BI Using SQL Server stored procedures

NOTE: The following works for the "Import ...READ MORE

Dec 14, 2018 in Power BI by Upasana
 • 8,620 points • 6,463 views
0 votes
1 answer

Count of Id within another Id

Hi Kalyan, Follow below steps: 1. Create a slicer ...READ MORE

Apr 17, 2019 in Power BI by Cherukuri
 • 33,050 points • 1,225 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

Feb 27, 2019 in Power BI by Phalguni
 • 1,020 points • 3,168 views
0 votes
1 answer

Power BI getting 2 week back same day value

You can use DATEADD() function to compute the 14 ...READ MORE

Apr 5, 2019 in Power BI by Upasana
 • 8,620 points • 1,539 views
0 votes
1 answer

Find number of days between 2 dates.

Hi Sindhu, Create a column with below code. ...READ MORE

Apr 8, 2019 in Power BI by Cherukuri
 • 33,050 points • 1,394 views
0 votes
1 answer

Power BI : Counting Failures

Try the following measure: Count of fails = ...READ MORE

Apr 5, 2019 in Power BI by Upasana
 • 8,620 points • 1,512 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.