power

Hello Everyone, I would greatly appreciate any help anyone may have on this problem, I have combed the internet looking for an answer but have only slightly gotten close so here we go.... Is there anyway possible to retrieve data from the power pivot data model that has been loaded from power...

I perform a monthly analysis using source data that is over 400K lines of data. Each line contains information like transaction total, commission amount, and commission percentage. Currently, I have to manually remove any lines that fall within certain criteria. For example, if a line has a...

I have 4 workbooks. Each contains two columns of data pulled from drop-down lists. When I use Power Query to combine the workbook data, everything comes over except from the two columns that contain drop-down data. How do I get Power query to pull this data over? Thank you.

Hi i have worked before with Excel 2013/64 bit and used Power Query and the function Append, in order to consolidate data from multiple Excel files into one file. Now when i use the built-in Power Query in Excel 2016/64 bit i do not have the opportunity in Append to consolidate more than 2...

Hi, I have a table in Power Query that mostly contains numeric data. Therefore, I want to align the column headers to the right so they are right-aligned with the numbers. This way, when I refresh the query, and Excel populates the table on the worksheet, the column headers will align with...

I'm attempting to create a table to store all of my functions in. What I would like to do is have power query loop through this table and load in all the functions in said table, but I can't seem to find any way to make this happen. I assume there is a way, I just don't know enough yet about...

Hi All, When we have the data ready for Power BI, does it have any in house function we can group the one column of the data? For instance, I have one data set and one column is the age from 17 to 99 so Does Power BI can group them somehow or customized so we have three age groups...

Hello, Regarding the binding of tables in Power BI, I would like to know how to make this connection, in the habitiude in SQL, we do the join or the connection between the tables with a primary key, but in Power BI I noted that There are linked tables with other fields. For example in this...

Hi All, I'm new here. I have a power query filter question, I want to filter the month as last year of this month (ie current month no.). I filtered the year but I want to make the month dynamic. Using this filter function how to make Date.Month([Calendar]) = calculate as current month no. =...

I'm trying to covert the following Excel IF statement to a custom column in Power BI: =IF(O2<>P2,IF(O2>0,O2,P2),IF(P2=0, N/A,P2)) (replacing the cells with the column names) I cannot for the life of me figure out the syntax. Any assistance is GREATLY appreciated.

I would like to create a calendar table in the data model to be able to group by week.Weeks are 5 days per week - Monday to Friday. So, my calendar starts from: 8/6/2018 to 7/26/2019 Week 1 starts from 8/6/2018 to 8/10/2018 And every 5 weeks, we start a new week 1. Can anybody, please help...

Hi all, looking for advice on a purchase. I currently have a Dell 8930 with 64gb ram, I7, m2 ssd. Looking to gain speed. I was thinking of getting an i9, with the same specs above. My budget is $2500-3000. And I live inside power pivot and power query pulling data from our on site sql server...

Fairly new to the world of Power Query and BI but loving it. I am sure this has probably been asked and answered before but I have searched quite a bit and tried different things but have not had any success. I receive a monthly excel file that I receive from a vendor that has Total Hours...

Hi, is it possible to simply update an existing power query with no knowledge of how they work? I have a calculation file which I inherited and want to update it to account for the current year and am a complete novice when it comes to power queries and power pivots. Currently, I have added...

Hello dear Power Bi Community, I'm pretty new into Power BI, so please excuse if I might need some pretty basic help here. I was trying to find some help here already and eventhough similar posts exist, I didn`t find anything yet which would cover my specific needs. I would like to...

Hi all I am learning to use power pivot to gather data in from analyses services server. Now issue is, based on the date, there can be lots of data. I only need say one month or week worth daily, and now and then 6 months or so. I can limit date data that is imported to pp, when creating power...

HI, I have a power query table with payments made on a transaction. I would like to have all payments on one line for each transaction so I can link them to the sales table. But if a customer paid with 2 credit cards in power query it is listed on 2 lines. I was hoping to use the un pivot and...

Good Day, Thank you in advance for answering this question. I can't combine two fields with an "x" value. For example, I'm combining lumber height & width so I write a calculated column =CONCATENATE(Data[Height],[Width]) and it shows 812 instead of 8x12. So then I read several websites &...

Does anyone know how to connect to an iqy through Power Query? Currently I'm using Power Query to connect to separate Excel file that contains the iqy. I would really like to skip the "middleman" and use Power Query to direct connect to my iqy. Thanks in advance.

Hello and thank you in advance if you can help, I am using excel 2019 on a desktop, not Power Bi. I had posted this in the Power Bi section of this forum, but I think now, because I am not using power Bi but Power Pivot in excel 2019, I should have posted it here. I am trying to create a...