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,730 points
3,475 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,730 points
7,693 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,730 points
1,353 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,730 points
1,970 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,730 points
2,482 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,730 points
1,200 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,730 points
3,089 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,730 points

edited Sep 25, 2020 by Gitika 5,697 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,730 points
23,545 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,700 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,730 points
1,984 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,730 points
4,851 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,730 points
1,201 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,730 points
2,188 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,730 points
4,389 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,730 points
13,938 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,730 points
2,343 views
0 votes
1 answer

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

Some common reason include data privacy settings ...READ MORE

Oct 10, 2023 in Power BI by Monika kale

edited Mar 5 1,529 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,730 points
1,182 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
2,559 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
2,246 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
2,511 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,730 points
7,938 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,730 points
2,072 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
1,280 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,730 points
2,507 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,730 points
4,567 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,730 points
5,317 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,730 points
2,129 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,457 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,730 points
1,477 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
1,472 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
2,208 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,730 points
4,287 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
2,003 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,730 points
32,123 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,336 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,730 points
1,534 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,730 points
2,641 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,971 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
3,268 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
1,199 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,730 points
1,489 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,730 points
1,347 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,730 points
5,334 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,730 points
6,977 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,730 points
12,871 views
0 votes
3 answers

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

a quick and easy way, without any ...READ MORE

Jul 10, 2021 in Power BI by anonymous

edited Mar 5 110,876 views