Trending questions in Power BI

+3 votes
1 answer

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

Mar 8, 2019 in Power BI by Cherukuri
• 32,490 points
37,832 views
0 votes
1 answer

How to replace Blank with "0" in Power BI Visual?

Hi, Sujit You can do this in two ...READ MORE

Feb 7 in Power BI by Gitika
• 42,520 points
12,249 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

2 days ago in Power BI by Gitika
• 42,520 points
52 views
0 votes
1 answer
0 votes
1 answer

How to change import mode to direct mode of connection in powerBI

Create a new file connect in import ...READ MORE

2 days ago in Power BI by anonymous
• 42,520 points
11 views
0 votes
1 answer

How to add a One drive Excel as a Data set in Power BI?

If the one Drive is from your ...READ MORE

2 days ago in Power BI by anonymous
• 42,520 points
10 views
0 votes
1 answer

Is it possible to use multiple dataset for one report?

Yes, of course, you can load a few ...READ MORE

2 days ago in Power BI by Gitika
• 42,520 points
9 views
0 votes
1 answer

Do we have any auto email functionality in power BI?

You can embed an email link with ...READ MORE

2 days ago in Power BI by anonymous
• 42,520 points
9 views
0 votes
1 answer

How to convert date format in PowerBI?

Change the column data type in excel ...READ MORE

2 days ago in Power BI by anonymous
• 42,520 points
9 views
0 votes
1 answer

How to create a Measure using Power BI DAX?

The following steps make your task simple ...READ MORE

4 days ago in Power BI by Gitika
• 42,520 points
19 views
0 votes
1 answer

How to connect to data with PowerBI desktop?

With Power BI Desktop, you can connect ...READ MORE

4 days ago in Power BI by Rajiv
• 3,400 points
14 views
0 votes
1 answer

How to analyze the data in Power BI using Excel?

Once you've enabled editing and content, Excel ...READ MORE

4 days ago in Power BI by Gitika
• 42,520 points
9 views
0 votes
1 answer

Format Data to tabular structure in Excel - Power m Query - Excel

Hi, @Kiranbvsn You can check this out: https://www.howtoexcel.org/ ...READ MORE

4 days ago in Power BI by Gitika
• 42,520 points
52 views
0 votes
2 answers

Transform a heavy calculated measure (accumulated) into a column in Power BI

Hello, @Marinafr, If you are using Pro License ...READ MORE

Oct 23 in Power BI by Rajiv
• 3,400 points
76 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 in Power BI by anonymous
• 42,520 points
29 views
0 votes
1 answer

Import Excel data to power Bi service

There is a  way that is directly ...READ MORE

Oct 22 in Power BI by Gitika
• 42,520 points
21 views
0 votes
1 answer

Error: We couldn't find any data in your Excel workbook

To import from Excel into the Power ...READ MORE

Oct 22 in Power BI by Gitika
• 42,520 points
20 views
0 votes
1 answer

How to import data model from Excel in PowerBI?

You may try to divide your data ...READ MORE

Oct 22 in Power BI by anonymous
• 42,520 points
14 views
0 votes
1 answer

How do you Hide and Unhide a Specific Report in Power BI?

In the menu bar, choose the Selection ...READ MORE

Oct 20 in Power BI by Gitika
• 42,520 points
25 views
0 votes
1 answer

How to Toggle Between Two Option and Make it Interact with the rest of the Visualizations in a Report?

Toggling is an action that is achieved ...READ MORE

Oct 20 in Power BI by anonymous
• 42,520 points
20 views
0 votes
1 answer

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

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

Oct 20 in Power BI by anonymous
• 42,520 points
20 views
0 votes
1 answer

How can You Change the Value Measure to Show Multiple Measures Dynamically?

You can dynamically change and switch functions ...READ MORE

Oct 20 in Power BI by Gitika
• 42,520 points
19 views
0 votes
1 answer

Difference between Power BI vs Tableau.

Here you go!  Feature Power BI Tableau Data visualization Focuses only on ...READ MORE

Oct 20 in Power BI by Gitika
• 42,520 points
17 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 in Power BI by Gitika
• 42,520 points
65 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 in Power BI by Gitika
• 42,520 points
33 views
0 votes
1 answer

How to measure as date variable when calculating time periods in Powerpivot?

You were pretty close - the trick ...READ MORE

Oct 8 in Power BI by Andi Mohor
27 views
0 votes
1 answer

How do I get my DAX measure to calculate grouped values?

Try this: Total Usage:= SUMX( VALUES(MyTable[SensorID]), [Usage]) An alternative ...READ MORE

Oct 8 in Power BI by Gitika
• 42,520 points
22 views
0 votes
1 answer

How DAX Difference between naked SUM and sum wrapped in CALCULATE?

This is materially different than the question ...READ MORE

Oct 8 in Power BI by Gitika
• 42,520 points
17 views
0 votes
1 answer

Add leading 0 (zero) to month number in power BI

You can use the FORMAT function for this: Expiry_MonthYear_Sorter = ...READ MORE

Oct 7 in Power BI by Gitika
• 42,520 points
36 views
0 votes
1 answer

DAX Previous Month to date total is giving entire previous month's entire total

You can go through this: PMYTD = ...READ MORE

Oct 7 in Power BI by Gitika
• 42,520 points
25 views
0 votes
1 answer

DAX / PowerPivot query functions to spread aggregated values over time period

The solution below assumes a table called ...READ MORE

Oct 5 in Power BI by Gitika
• 42,520 points
42 views
0 votes
1 answer

DAX. Problem with subtotals and grand totals

Create a new measure for the km ...READ MORE

Oct 5 in Power BI by Gitika
• 42,520 points
27 views
0 votes
1 answer

How do I use the DAX function ParallelPeriod?

The DAX expression you used in the ...READ MORE

Oct 5 in Power BI by Gitika
• 42,520 points
27 views
0 votes
1 answer

DAX Userelationship function

 You need a way for the measure ...READ MORE

Oct 5 in Power BI by Gitika
• 42,520 points
26 views
0 votes
1 answer

Excel PowerPivot DAX Calculated Field

You should create a relationship between each ...READ MORE

Oct 5 in Power BI by Gitika
• 42,520 points
22 views
0 votes
1 answer

DAX formula to concatenate three columns.

If the columns are already text, you ...READ MORE

Oct 1 in Power BI by Gitika
• 42,520 points
136 views
0 votes
1 answer

DAX EARLIER() function in Power Query

Solutions in the code below. Notice that ...READ MORE

Oct 1 in Power BI by Gitika
• 42,520 points
81 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 in Power BI by Gitika
• 42,520 points
74 views
0 votes
1 answer

DAX function to create LY Measure without date dimension

It should be fairly simple (sumx of ...READ MORE

Oct 1 in Power BI by Gitika
• 42,520 points
26 views
0 votes
1 answer

How can I join tables using only DAX?

You can see this below example: FILTER('InternetSales_USD' ...READ MORE

Oct 1 in Power BI by Gitika
• 42,520 points
25 views
0 votes
1 answer

How do I count rows in one table based on values in another table using DAX?

If the tables are related, this is ...READ MORE

Sep 24 in Power BI by Gitika
• 42,520 points
277 views
0 votes
1 answer
0 votes
1 answer

Understanding the DAX CALCULATE function

Using the CALCULATE function makes the DAX perform a context ...READ MORE

Sep 28 in Power BI by Gitika
• 42,520 points
44 views
0 votes
1 answer

How to calculate average inventory in power bi?

Hi @There, Is there any index field in ...READ MORE

Sep 28 in Power BI by Gitika
• 42,520 points
46 views
0 votes
1 answer

Recursive logic in DAX

Hey,  The only option is to break down ...READ MORE

Sep 28 in Power BI by Gitika
• 42,520 points
42 views
0 votes
1 answer

Recursion in DAX

You can check this out:  DECLARE @myTable as ...READ MORE

Sep 28 in Power BI by Gitika
• 42,520 points
31 views
0 votes
2 answers

Power Bi Questions

Hi, @Vnk, Despite the efficiencies achieved by the ...READ MORE

Sep 24 in Power BI by Gitika
• 42,520 points
85 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 in Power BI by Gitika
• 42,520 points
52 views