Trending questions in Power BI

0 votes
1 answer

Scraping Data from a website which uses Power BI - retrieving data from Power BI on a website

Putting the scroll part and the JSON ...READ MORE

Dec 22, 2020 in Power BI by Gitika
• 65,730 points
5,619 views
0 votes
1 answer
0 votes
0 answers

Dax calculation

Area  22msqrt    ---- Result %R         0.10 ------ 10% Vs ...READ MORE

Apr 22, 2021 in Power BI by vnk
• 390 points

edited Mar 4 69 views
0 votes
0 answers

DAX To Split column into multiple rows

Dear all I have a table in Power ...READ MORE

Apr 21, 2021 in Power BI by Marcelo
• 120 points

edited Mar 4 77 views
0 votes
1 answer

How to measure in DAX to calculate YTD for chosen month only for Power BI?

If you use the date column from FactTable, ...READ MORE

Dec 22, 2020 in Power BI by Gitika
• 65,730 points
5,183 views
0 votes
0 answers

Create a Fiscal Years, Quarters, Month, Day, Weeks in Power bi

How to create a Fiscal calander  using ...READ MORE

Apr 12, 2021 in Power BI by vnk
• 390 points

edited Mar 4 117 views
0 votes
0 answers

Z order in power bi

What is Z Order in Power BI? ...READ MORE

Apr 12, 2021 in Power BI by vnk
• 390 points

edited Mar 4 100 views
0 votes
1 answer

Power BI (DAX): Distinct Count Filtered by Condition

You can go with this: DistinctCountActiveMonths = CALCULATE( ...READ MORE

Nov 18, 2020 in Power BI by anonymous
• 65,730 points
5,884 views
0 votes
0 answers

Difference between On-premises server and Cloud server

Difference between On-premises server and Cloud server. step ...READ MORE

Mar 30, 2021 in Power BI by vnk
• 390 points

edited Mar 4 78 views
0 votes
1 answer

How to convert eight digit yyyymmdd to date using DAX in Power BI ?

You can go through this: column = IFERROR( ...READ MORE

Dec 8, 2020 in Power BI by Gitika
• 65,730 points
4,617 views
0 votes
1 answer

How to create action button in Power BI?

Hi Raghav, Follow the below steps: 1. Click on ...READ MORE

Jun 20, 2019 in Power BI by Cherukuri
• 33,050 points
27,808 views
0 votes
1 answer

How to ignore a slicer for one measure, but apply it on another?

In order to ignore Slicer you need ...READ MORE

Oct 1, 2020 in Power BI by Gitika
• 65,730 points
7,544 views
0 votes
0 answers

Difference between On-premises server and Cloud server

1) Difference between On-premises server and Cloud ...READ MORE

Mar 19, 2021 in Power BI by vnk
• 390 points

edited Mar 4 109 views
0 votes
1 answer

Using RELATED function in DAX with USERELATIONSHIP

Here's an example using the AdventureWorksDW data ...READ MORE

Nov 18, 2020 in Power BI by anonymous
• 65,730 points
5,264 views
0 votes
0 answers

Count rows for calculated measure

Hi, I have a sample data table ...READ MORE

Mar 9, 2021 in Power BI by Manjunath

edited Mar 4 97 views
0 votes
1 answer

How to parse a .json column in Power BI?

Use Json.Document function like this let ...READ MORE

Dec 21, 2020 in Power BI by Gitika
• 65,730 points
3,219 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

Oct 5, 2018 in Power BI by Kalgi
• 52,340 points
38,118 views
+2 votes
1 answer

how to split country & city in Dax power bi

After loading the dataset, you can split ...READ MORE

Nov 25, 2020 in Power BI by Gitika
• 65,730 points
3,984 views
0 votes
1 answer

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

You can use: MonthName = FORMAT(DATE(1, [Num], 1), ...READ MORE

Sep 24, 2020 in Power BI by Alisha
6,616 views
0 votes
1 answer

how to connect firebase data into power bi

Hi, @There, Click “Get Data->Blank Query” to add ...READ MORE

Dec 18, 2020 in Power BI by Gitika
• 65,730 points
2,867 views
0 votes
1 answer

how to create snapshots in power BI?

Snapshots enable faster loading of specific properties. Follow ...READ MORE

Oct 29, 2019 in Power BI by Cherukuri
• 33,050 points
20,713 views
0 votes
1 answer

Couldn't retrieve the data for this visual.

The error you mentioned here is usually ...READ MORE

Nov 2, 2020 in Power BI by Gitika
• 65,730 points
4,555 views
0 votes
1 answer

How to use Dynamic DAX Number Format in power BI?

You can give them the same display ...READ MORE

Dec 8, 2020 in Power BI by Gitika
• 65,730 points
2,655 views
0 votes
1 answer

Can't get client-credentials access token to authorize Power BI

With the assistance of some Microsoft folks ...READ MORE

Dec 18, 2020 in Power BI by Gitika
• 65,730 points
2,157 views
0 votes
1 answer

Slicer with conditions - if value selected,select related values

I assume that both tables are unrelated ...READ MORE

Nov 12, 2020 in Power BI by Gitika
• 65,730 points
3,697 views
0 votes
1 answer

I have a web API with basic authorisation and username and password. How do i connect to it in Power BI?

Hey, @There, I found your query is quite ...READ MORE

Oct 29, 2020 in Power BI by Gitika
• 65,730 points
4,172 views
0 votes
1 answer

DAX Calculation the Max for a Group.

You can try this out:  Desired Output=CALCULATE(MAX([Check]), ...READ MORE

Sep 25, 2020 in Power BI by Gitika
• 65,730 points

edited Sep 25, 2020 by Gitika 5,607 views
0 votes
1 answer

In DAX, how do I RETURN the sum of a calculated column from a DAX Table Variable (created via ADDCOLUMN)?

You can access column variables of previously ...READ MORE

Oct 8, 2020 in Power BI by Gitika
• 65,730 points
4,869 views
0 votes
1 answer

How to restart running total column with Power BI Desktop DAX?

This is not only a running total ...READ MORE

Dec 8, 2020 in Power BI by Gitika
• 65,730 points
2,110 views
0 votes
1 answer

How to create summary table based on selected filters/slicers?

Here are the steps you can follow: 1. ...READ MORE

Nov 12, 2020 in Power BI by anonymous
• 65,730 points
3,227 views
0 votes
1 answer

Can we delete datasets in pro from works space in Power Bi

Hi, @Naveen, Please go through the given below ...READ MORE

Nov 26, 2020 in Power BI by Gitika
• 65,730 points
2,583 views
0 votes
1 answer

How can I make my visual distinct count total match the row by row sum when applying filters in PowerBI?

The COUNTROWS function can be used to ...READ MORE

Jul 28, 2020 in Power BI by Gitika
• 65,730 points
7,841 views
0 votes
1 answer

Failed to load files, showing please wait while we establish a connection to <filename>'.

 One thing you can do is that ...READ MORE

Oct 22, 2020 in Power BI by anonymous
• 65,730 points
3,829 views
0 votes
1 answer

Is it possible to use R Plotly library in R Script Visual of Power BI?

For newer versions of PowerBI, it's also ...READ MORE

Dec 8, 2020 in Power BI by Gitika
• 65,730 points
1,819 views
0 votes
1 answer

Direct Query Cannot Load Model. Login Failed for user. The exception was by raised by the IDbConnect

The current power bi pbix file connection ...READ MORE

Nov 16, 2020 in Power BI by Gitika
• 65,730 points
2,709 views
0 votes
1 answer

How to connect google sheet with power bi?

If you're not limited to R Studio, ...READ MORE

Dec 22, 2020 in Power BI by Gitika
• 65,730 points
1,122 views
0 votes
1 answer

How to calculate PowerBI / DAX - Row wise division by measure?

As for your question, I think you're ...READ MORE

Oct 8, 2020 in Power BI by Gitika
• 65,730 points
4,320 views
0 votes
1 answer

Task's Exception(s) were not observed.

I suggest you go the the "Files" - ...READ MORE

Nov 2, 2020 in Power BI by Gitika
• 65,730 points
3,205 views
0 votes
1 answer

Cannot install Microsoft Power Bi Postgre SQL connector

There seems to be some problem with ...READ MORE

Dec 22, 2020 in Power BI by Gitika
• 65,730 points
1,059 views
0 votes
0 answers

Tableau or PowerBI- which certification is better for an experienced BI person to get a job in Australia?

Um having experience of Informatica, SAP Business ...READ MORE

Jan 11, 2021 in Power BI by Edureka

edited Mar 4 92 views
0 votes
1 answer

how to sync firebase data into power bi?

Hi, @There, As far as I know, it ...READ MORE

Dec 18, 2020 in Power BI by Gitika
• 65,730 points
1,058 views
0 votes
1 answer

Error : Function 'GROUPBY' scalar expressions have to be Aggregation functions over CurrentGroup().

The error says you need to use ...READ MORE

Sep 24, 2020 in Power BI by Gitika
• 65,730 points
4,702 views
0 votes
1 answer

Cumulative distinct count filtered by last value - DAX

MyFilteredCumulativeMeasure = COUNTROWS( FILTER( ...READ MORE

Nov 18, 2020 in Power BI by anonymous
• 65,730 points
2,300 views
0 votes
1 answer

How do I use Power BI Desktop with version control?

I would add a "Parameters" Query (a ...READ MORE

Dec 18, 2020 in Power BI by Gitika
• 65,730 points
940 views
0 votes
1 answer

What is the difference Between SUM() and SUMX()

Sum function (Sum()) takes the data columns ...READ MORE

Oct 20, 2020 in Power BI by anonymous
• 65,730 points
3,443 views
0 votes
0 answers

how to connect appsflyer data to power bi

how to connect appsflyer data to power ...READ MORE

Dec 18, 2020 in Power BI by Edureka
• 160 points
865 views
0 votes
1 answer

Several errors occurred during data refresh.

"Connexion successful" mean "the network connection is ...READ MORE

Nov 16, 2020 in Power BI by Gitika
• 65,730 points
2,208 views
0 votes
1 answer

PowerPivot DAX - Dynamic Ranking Per Group (Min Per Group)

Firstly create a basic measure [Amount] to sum the ...READ MORE

Nov 18, 2020 in Power BI by Gitika
• 65,730 points
2,055 views
0 votes
1 answer

user select on filter to show the bars

Hi, @There, There are multiple steps which you ...READ MORE

Dec 10, 2020 in Power BI by Gitika
• 65,730 points
996 views