Trending questions in Power BI

0 votes
1 answer

Is it possible to restrict SQL query result visibility by column data using RLS?

RLS is on row level, you can ...READ MORE

Nov 12, 2020 in Power BI by Gitika
 • 65,770 points • 646 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, 2020 in Power BI by Rajiv
 • 8,870 points • 1,355 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,077 views
0 votes
1 answer

How to verify that R and R studio are installed on your system?

To verify that R and R studio ...READ MORE

Nov 11, 2020 in Power BI by Gitika
 • 65,770 points • 515 views
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,056 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,020 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,256 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,751 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 • 840 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,843 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,102 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

Oct 29, 2020 in Power BI by anonymous
 • 65,770 points • 696 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 • 648 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 • 689 views
0 votes
1 answer

How to trim space from Power BI?

Hey, Make sure your column type is set ...READ MORE

Feb 6, 2020 in Power BI by Gitika
 • 65,770 points • 12,095 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 • 649 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,738 views
+2 votes
1 answer

How to connect to mysql database from power Bi?

Hi, Follow these steps, to connect to MYSQL ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
 • 33,030 points • 25,817 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 • 676 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 • 1,999 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 • 778 views
0 votes
1 answer

Count occurrences in DAX

You can use DAX functions to do ...READ MORE

Mar 9, 2019 in Power BI by Avantika
 • 1,520 points • 26,401 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,359 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,840 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,310 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,581 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,458 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 • 564 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,652 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,155 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 • 926 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 • 691 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 • 937 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,043 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 • 941 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 • 591 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 • 622 views
0 votes
2 answers

Power Bi Questions

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

Sep 24, 2020 in Power BI by Gitika
 • 65,770 points • 874 views
+1 vote
1 answer

Topic -Power BI Paginated Reports with Excel or CSV file data source

Hi, @There, With Power BI Desktop, you can ...READ MORE

Aug 28, 2020 in Power BI by Carlos
 • 1,969 views
0 votes
1 answer

Calculate GB Using DAX in Power BI

Hi, @Vnk You can go through this regarding ...READ MORE

Jun 30, 2020 in Power BI by Gitika
 • 65,770 points • 4,738 views
+1 vote
1 answer

Connectivity between Control-M and Power BI

There are few new APIs that will allow ...READ MORE

Aug 28, 2020 in Power BI by Rajiv
 • 8,870 points • 1,869 views
0 votes
1 answer

How to troubleshoot a refresh on data set in power bi service

Hello, @vnk, You may see an error when ...READ MORE

Sep 14, 2020 in Power BI by Gitika
 • 65,770 points • 1,040 views
–1 vote
1 answer

How do I prove that I did the assignment?

Hi,@ Obi First do not get anxious, clam ...READ MORE

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

dax calculation for last N days

Hi, @Vnk, Regarding your above query, you can ...READ MORE

Jun 30, 2020 in Power BI by Gitika
 • 65,770 points • 4,125 views
0 votes
1 answer

Creating a stacked chart from 1 column in Power BI

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

Aug 3, 2020 in Power BI by Reshma
 • 1,986 views
+2 votes
2 answers

How do I undo something in Power BI?

To undo your last action or last few actions, press ...READ MORE

Oct 15, 2018 in Power BI by Hannah
 • 18,520 points • 30,108 views
0 votes
1 answer

calculation of hourly dax

Hi, @Vnk, Regarding your above query, you can ...READ MORE

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

last 10 days data based on Date&time

Hi, @Vnk, Regarding your query, you have to ...READ MORE

Jun 4, 2020 in Power BI by Gitika
 • 65,770 points • 3,535 views
0 votes
1 answer

Stacked chart with dates on X-axis

Hi, @Hacke Regarding your query, you can follow ...READ MORE

Jun 30, 2020 in Power BI by Gitika
 • 65,770 points • 2,079 views
+1 vote
3 answers

Send dashboards and reports as automated emails on power bi

also, check - https://bihelper.tech It is a cloud service ...READ MORE

Oct 14, 2019 in Power BI by Andrew Caulton
 • 21,128 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.