Recent questions tagged powerquery

0 votes

316 views

1 answer

powerquery - Dual data type of specific column as per different selection?

I have 2 column "Order Quantity"(data type whole no) and "Product"(data type text). Now what I want, ... /65840673/dual-data-type-of-specific-column-as-per-different-selection...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

446 views

1 answer

powerquery - Excel, Power Query: Pull columns from source workbook based on date

So this is a longshot, as I'm thinking it might be too complicated to explain an answer (if there is one ... /excel-power-query-pull-columns-from-source-workbook-based-on-date...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

557 views

1 answer

powerquery - Power Query in EXCEL: Creating a Calendar using the Calendar DAX Function

Using Power Query in Excel, how can you create a table of dates using the Calendar DAX function? I tried ... query-in-excel-creating-a-calendar-using-the-calendar-dax-function...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

609 views

1 answer

powerquery - Table.TransformColumns by Columns' Value

I have been stuck on something on PowerQuery for hours now and I cannot seem to find a solution ... //stackoverflow.com/questions/65887249/table-transformcolumns-by-columns-value...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

683 views

1 answer

powerquery - Power Query: Get Data from an online Excel workbook (OneDrive, SharePoint)

I've asked this before, and I think I got some comments on the question not being specific/researched enough ... -query-get-data-from-an-online-excel-workbook-onedrive-sharepoint...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

326 views

1 answer

powerquery - Consoling in visual studio

I am using Visual Studio 2019 for Power Query. I am looking to print some values in the console but ... :https://stackoverflow.com/questions/65908186/consoling-in-visual-studio...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

598 views

1 answer

powerquery - Combine Tables matching a name pattern in Power Query

I am trying to combine many tables that has a name that matches a patterns. So far, I have extracted ... questions/65912640/combine-tables-matching-a-name-pattern-in-power-query...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

470 views

1 answer

powerquery - NASA API into table in excel

I'm trying to download weather related data using the Nasa API into excel using powerquery. I'm trying to ... //stackoverflow.com/questions/65913144/nasa-api-into-table-in-excel...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

440 views

1 answer

powerquery - Automatic column deletion in Power BI query

Every 4 hours SAP automatically generate report within the same Excel file. The report name called Data . ... com/questions/65916374/automatic-column-deletion-in-power-bi-query...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

296 views

1 answer

powerquery - Determine column on which invoke custom function

I am trying to invoke a function on an added column that will concatenate two columns. The catch is ... .com/questions/65921741/determine-column-on-which-invoke-custom-function...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

350 views

1 answer

powerquery - Excel Power Query: how to prevent multiple requests for the same source (web json)?

I have a REST endpoint that queries the data in JIRA and returns the data for activeSprint and previousSprint so the ... -to-prevent-multiple-requests-for-the-same-source-web-jso...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

404 views

1 answer

powerquery - Refreshing excel query causes excel lose functionality in new file

I have a power query, after refreshing it and creating a new workbook to paste query results in it, the ... /refreshing-excel-query-causes-excel-lose-functionality-in-new-file...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

510 views

1 answer

powerquery - Non Equi Join Excel Power Query

I'm wondering how to get a non-equi join in Excel power query. In sql terms, I'd like to get ... https://stackoverflow.com/questions/66053033/non-equi-join-excel-power-query...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

483 views

1 answer

powerquery - Non Equi Join Excel Power Query

I'm wondering how to get a non-equi join in Excel power query. In sql terms, I'd like to get ... https://stackoverflow.com/questions/66053033/non-equi-join-excel-power-query...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

555 views

1 answer

powerquery - PowerBI Working hours calculation without start end time

I have this table with only start time of every task. What I want to do is to calculate for every user his ... it takes min/max of the date period: Any help much appreciated...

asked Jan 27, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags