Most answered questions in Power BI

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

Oct 29, 2020 in Power BI by anonymous
 • 65,770 points • 1,137 views
0 votes
1 answer

How to find out what all datasets are currently running without manually seeing the each dataset refresh history in PowerBI

Go to ur workspace, click on dataset ...READ MORE

Oct 29, 2020 in Power BI by Gitika
 • 65,770 points • 959 views
0 votes
1 answer

Do we have any auto email functionality in power BI?

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

Oct 29, 2020 in Power BI by anonymous
 • 65,770 points • 699 views
0 votes
1 answer

Why users can't see the export option in Power Bi services? It is disabled, all users have given member permissions. However few can see and few can't? Any idea

In tenants settings under admin settings that ...READ MORE

Oct 29, 2020 in Power BI by Gitika
 • 65,770 points • 7,433 views
0 votes
1 answer

How to convert date format in PowerBI?

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

Oct 29, 2020 in Power BI by anonymous
 • 65,770 points • 1,127 views
0 votes
1 answer

How to create a Measure using Power BI DAX?

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

Oct 27, 2020 in Power BI by Gitika
 • 65,770 points • 1,084 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

Oct 27, 2020 in Power BI by Gitika
 • 65,770 points • 704 views
0 votes
1 answer

How to connect to data with PowerBI desktop?

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

Oct 27, 2020 in Power BI by Rajiv
 • 8,870 points • 739 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

Oct 27, 2020 in Power BI by Gitika
 • 65,770 points • 773 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,770 points • 3,608 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, 2020 in Power BI by anonymous
 • 65,770 points • 1,728 views
0 votes
1 answer

Import Excel data to power Bi service

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

Oct 22, 2020 in Power BI by Gitika
 • 65,770 points • 944 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, 2020 in Power BI by Gitika
 • 65,770 points • 2,225 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, 2020 in Power BI by Gitika
 • 65,770 points • 10,901 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, 2020 in Power BI by Gitika
 • 65,770 points • 2,267 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, 2020 in Power BI by anonymous
 • 65,770 points • 1,154 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, 2020 in Power BI by Gitika
 • 65,770 points • 616 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,770 points • 3,256 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, 2020 in Power BI by Andi Mohor
 • 1,472 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,770 points • 4,048 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, 2020 in Power BI by Gitika
 • 65,770 points • 757 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, 2020 in Power BI by Gitika
 • 65,770 points • 1,816 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,770 points • 4,657 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 8, 2020 in Power BI by Gitika
 • 65,770 points • 3,496 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 8, 2020 in Power BI by Gitika
 • 65,770 points • 3,294 views
0 votes
1 answer

DAX. Problem with subtotals and grand totals

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

Oct 5, 2020 in Power BI by Gitika
 • 65,770 points • 1,896 views
0 votes
1 answer

Excel PowerPivot DAX Calculated Field

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

Oct 5, 2020 in Power BI by Gitika
 • 65,770 points • 656 views
0 votes
1 answer

DAX Userelationship function

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

Oct 5, 2020 in Power BI by Gitika
 • 65,770 points • 1,347 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, 2020 in Power BI by Gitika
 • 65,770 points • 1,442 views
0 votes
1 answer

How do I use the DAX function ParallelPeriod?

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

Oct 5, 2020 in Power BI by Gitika
 • 65,770 points • 1,059 views
0 votes
1 answer

DAX formula to concatenate three columns.

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

Oct 1, 2020 in Power BI by Gitika
 • 65,770 points • 1,880 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, 2020 in Power BI by Gitika
 • 65,770 points • 731 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, 2020 in Power BI by Gitika
 • 65,770 points • 1,021 views
0 votes
1 answer

DAX EARLIER() function in Power Query

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

Oct 1, 2020 in Power BI by Gitika
 • 65,770 points • 3,125 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,770 points • 7,107 views
0 votes
1 answer

Hi, I am learning Power BI and trying to understand how calculate works without filter? = calculate(sum(sales.total_amout)). why cant we give sum(sales.total_amount)?

Hello @Amitha, The CALCULATE function is useful because ...READ MORE

Oct 1, 2020 in Power BI by Roshni
 • 10,480 points • 1,518 views
0 votes
1 answer

Error: the column 'People[FullName]' either doesn't exist or doesn't have a relationship to any table available in the current context.

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

Sep 28, 2020 in Power BI by Gitika
 • 65,770 points • 1,105 views
0 votes
1 answer

Understanding the DAX CALCULATE function

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

Sep 28, 2020 in Power BI by Gitika
 • 65,770 points • 1,693 views
0 votes
1 answer

Recursive logic in DAX

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

Sep 28, 2020 in Power BI by Gitika
 • 65,770 points • 2,307 views
0 votes
1 answer

Recursion in DAX

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

Sep 28, 2020 in Power BI by Gitika
 • 65,770 points • 1,031 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, 2020 in Power BI by Gitika
 • 65,770 points • 2,800 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,770 points
edited Sep 25, 2020 by Gitika • 5,345 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, 2020 in Power BI by Gitika
 • 65,770 points • 22,914 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,402 views
0 votes
1 answer

Left Outer Join using DAX in PowerBI.

You can simply write a few measures ...READ MORE

Sep 24, 2020 in Power BI by Gitika
 • 65,770 points • 1,746 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,770 points • 4,405 views
0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

Sep 24, 2020 in Power BI by Gitika
 • 65,770 points • 1,912 views
0 votes
1 answer

DAX Calculate function with and without FILTER

You could make [Measure12] return the same results as ...READ MORE

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

What is the difference between DAX and Power Query?

DAX stands for Data Analysis Expressions. DAX ...READ MORE

Sep 24, 2020 in Power BI by Gitika
 • 65,770 points • 13,587 views
0 votes
1 answer

What is the difference between PowerPivot, Power Query and Power BI?

Power Query Power Query is a self-service ETL ...READ MORE

Sep 24, 2020 in Power BI by Gitika
 • 65,770 points • 2,092 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.