Trending questions in Power BI

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,850 points
158 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,850 points
262 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,850 points
1,392 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,850 points
140 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,850 points
1,013 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,850 points
136 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,850 points
975 views
0 votes
1 answer
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,850 points
874 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,850 points
404 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,850 points
681 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
345 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,850 points
468 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,850 points
427 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,850 points
855 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,850 points
813 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,850 points
190 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,850 points
240 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,850 points
220 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,850 points
424 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,850 points
117 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,850 points
279 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,850 points
585 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,850 points
370 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,850 points
144 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,850 points
242 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,850 points
419 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,850 points
176 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,850 points
246 views
0 votes
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,850 points
156 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,910 points
665 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
661 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,850 points
2,016 views
0 votes
1 answer

How to rename a column using DAX in Power BI?

Hi Ramya, I found these two function that ...READ MORE

Aug 22, 2019 in Power BI by anonymous
• 33,010 points

edited Dec 31, 2021 by Soumya 15,392 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
287 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,850 points
1,743 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,850 points
475 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,850 points
7,397 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,850 points
729 views
0 votes
1 answer

how to write dax calculation Power bi

Hi, @vnk You can make use of this ...READ MORE

Aug 5, 2020 in Power BI by code_Damon
268 views
0 votes
1 answer

Dax Calculations on Date&time

Hey, @Vnk, I hope you have a data ...READ MORE

Jun 30, 2020 in Power BI by Gitika
• 65,850 points
836 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
21,181 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,850 points
1,566 views
0 votes
0 answers

If invoice date is <= OTD then OT else Late and if OTD is blank then OT

I am getting an error message. I ...READ MORE

Jun 30, 2020 in Power BI by lcallicutt
• 120 points
373 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,010 points
16,448 views
0 votes
0 answers

How to check the dynamic file name exists in the downloads folder using UiPath ?

Hello folks, Every time I download the file ...READ MORE

Jun 10, 2020 in Power BI by usha
• 120 points
986 views
0 votes
0 answers

After connecting SharePoint List with Power BI, and editing data in query, all the data I want are in links

I've try so many ways to decode ...READ MORE

Jun 18, 2020 in Power BI by Dora
• 120 points
630 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,010 points
19,818 views
0 votes
1 answer

Dynamic title Based on Date

Hi, @Vnk, You can try this: [Date(WindowMax)(Title)] = WINDOW_MAX( ...READ MORE

Jun 15, 2020 in Power BI by Gitika
• 65,850 points
232 views
0 votes
0 answers

Combine two tables, filtering out duplicates from table two.

I want to combine two tables into ...READ MORE

May 12, 2020 in Power BI by Nikola
• 140 points
1,157 views