Latest questions in Power BI

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,910 points
2,596 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,910 points
6,508 views
0 votes
1 answer
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,910 points
866 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,910 points
1,373 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,910 points
2,107 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,910 points
735 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,910 points
2,495 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,910 points

edited Sep 25, 2020 by Gitika 4,822 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,910 points
22,030 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
5,839 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,910 points
1,466 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,910 points
3,581 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,910 points
712 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,910 points
1,636 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,910 points
3,553 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,910 points
13,000 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,910 points
1,828 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,910 points
846 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,910 points
742 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,579 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
1,653 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,603 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,910 points
7,099 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,910 points
1,424 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
756 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,910 points
1,829 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,910 points
3,761 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,910 points
4,285 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,910 points
1,554 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
1,001 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,910 points
858 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
841 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
1,816 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,910 points
3,238 views
0 votes
0 answers
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,678 views
0 votes
1 answer

How do I install PowerBI on Ubuntu ?

Hi, @Bhagyashri, Based on my research, currently, it ...READ MORE

Apr 23, 2020 in Power BI by Gitika
• 65,910 points
28,348 views
0 votes
0 answers

file must be character string

I am struggling with environmental asscocition analysis ...READ MORE

Mar 20, 2020 in Power BI by Girma
• 120 points
1,051 views
0 votes
1 answer

As a beginner, which bi tool do i need to learn to get job (tableau or power bi)?

Hey, If your focus is to get a ...READ MORE

Mar 16, 2020 in Power BI by Gitika
• 65,910 points
1,024 views
0 votes
1 answer

How to use play axis in stocked column chart

Hey Katyvin, If you want to use the ...READ MORE

Feb 18, 2020 in Power BI by Gitika
• 65,910 points
2,158 views
0 votes
0 answers

DataSource.Error: ADO.NET: R script error. Error in is.data.frame(x) : object 'ALL_Data' not found

I am trying to export data from ...READ MORE

Feb 14, 2020 in Power BI by ankita
• 120 points
2,522 views
0 votes
0 answers

How to work on existing power query using python

Hi I have an existing power query created ...READ MORE

Feb 7, 2020 in Power BI by Biswajith
• 120 points
2,560 views
0 votes
1 answer

How to create a new slicer to filter data by district manager in Power BI?

Follow the steps Open power bi  desktop nd ...READ MORE

Oct 10, 2023 in Power BI by Monika kale
816 views
0 votes
1 answer

How to Create and use doughnut charts in Power BI?

Hey, To create a doughnut chart in Power ...READ MORE

Feb 6, 2020 in Power BI by Gitika
• 65,910 points
893 views
0 votes
1 answer

How to create a new dashboard by pinning visualizations from a report in Power BI?

Hey, I can show some steps wise steps ...READ MORE

Feb 6, 2020 in Power BI by Gitika
• 65,910 points
931 views
0 votes
1 answer

How to create Pivot Tables in Power BI?

Hey, First of all, there is no "Pivot ...READ MORE

Feb 6, 2020 in Power BI by Gitika
• 65,910 points
4,565 views
0 votes
1 answer

How to make a table Hyperlink in Excel Power Pivot?

Hey, You can follow these steps to make a ...READ MORE

Feb 6, 2020 in Power BI by Gitika
• 65,910 points
5,825 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,910 points
11,458 views
0 votes
3 answers

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

so you are using the raw source ...READ MORE

Dec 15, 2020 in Power BI by Gitika
• 65,910 points
106,542 views