Power Tools

Power BI, Power Pivot, Power Query (Get and Transform), Power View, and Power Map

Latest updates Popular Newest Unanswered Unsolved

M
  • Sticky
Here are 30 reasons why you should be considering Power BI
2
Answers
11
Views
34K
Matt Allington
M
starl
  • Locked
  • Sticky
PowerPivot Version Information
Answers
0
Views
19K
starl
starl
B
using Power Query: Break a long, filtered, list of items into 60 rows on required number of sheets
Answers
1
Views
62
Kaper
Kaper
H
power query - apply transformation/cleaning of one query to the next query.
Answers
1
Views
80
ExcelToDAX
E
M
  • Solved
Getting data in correct column from pdf file
Answers
1
Views
65
MasterBash
M
V
  • Solved
Filter Table Visualization to Return All Valid Line Items
Answers
2
Views
84
Veritan
V
muhammad susanto
Get the refresh date & time in Power Query
Answers
6
Views
87
muhammad susanto
muhammad susanto
P
Inserting items to a list
Answers
0
Views
93
PQCurious
P
rjbinney
Editing 'Get Data from Web'
Answers
1
Views
95
Matt Allington
M
C
Connect PowerBi to excel sheet
Answers
1
Views
40
Matt Allington
M
S
Need chart as per image
2
Answers
12
Views
109
sksanjeev786
S
S
Create a function
Answers
1
Views
76
RoryA
RoryA
katsdelite
  • Solved
Power Query - split rows of data from multiple columns into rows with respective value on a separate line
Answers
4
Views
128
katsdelite
katsdelite
J
Power Query - Preview not Refreshed
Answers
3
Views
149
GraH
GraH
A
Transforming a Table in Excel Power Query: Grouping and Splitting Rows Based on Unique Order IDs
Answers
3
Views
141
alex78
A
I
Power Query M equivalent of excel conditional IFS formula for a conditional column
Answers
1
Views
121
Fluff
Fluff
I
Power Query Question: Is there a way to capture the date and time of a value change in a column and add a column with those captured Date and Time
Answers
2
Views
72
Fluff
Fluff
L
Very weird report output requires a transformation in PowerQuery;
Answers
2
Views
89
Kaper
Kaper
C
Power Pivot - Add Weekly totals from second query to main pivot table
Answers
3
Views
142
cwins
C
E
How should I id duplicate values?
Answers
1
Views
92
Matt Allington
M
M
  • Solved
New to Excel Power Query - Need to pull partial file name with most recent date
Answers
3
Views
94
datatronics505
datatronics505
X
Power Query Reference vs Duplicate for Performance
Answers
1
Views
90
JEC
JEC
You must log in or register to post here.

Forum statistics

Threads
1,223,838
Messages
6,174,937
Members
452,593
Latest member
Jason5710

Share this page

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