power

  1. E

    VBA - Create an array from Data within the Power Pivot Data Model sourced from Power Query

    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...
  2. R

    Is Power Query what I need?

    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...
  3. D

    Drop down data not loading when running power query

    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.
  4. B

    Append function for multiple files only possible for 2 files in Power Query/Excel 2016/64 bit?

    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...
  5. M

    Can You Align Table Headers In Power Query Table?

    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...
  6. M

    Looping through a table

    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...
  7. P

    Grouping function in Power BI

    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...
  8. A

    Join between tables

    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...
  9. J

    Power Query how to get dynamic month no. in a filter function

    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. =...
  10. M

    Converting IF statement to Power BI

    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.
  11. A

    Power Pivot

    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...
  12. S

    New PC purchase

    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...
  13. J

    Power Query - How to Power Query not to convert to day time format

    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...
  14. P

    Updating an existing PowerQuery formula?

    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...
  15. J

    Building a dynamic “Top N” Group and “Other” based on Last 12 Months Revenues

    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...
  16. nikio8

    PP date parameter from cubestabular ?

    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...
  17. S

    Power Query Unpivot?

    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...
  18. montyfern

    Using Concatenate in DAX in PowerPivot as a Measure

    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 &...
  19. D

    Power Query to iqy

    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.
  20. M

    Power Pivot measure dividing two other measures not working, please help.

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top