#powepivot #powerquery

WE NEED DATA TRANSFER TO TABLE AND EASY DATA ENTRY ........... SO I WAS FAILLED... I Don't know how to write vba coding As per my Question DATA Range : J7:MJ Table Range : C7:C24

We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also, I will Making Purchase Order Tracking System I was Jump Sheet Using Hyperlink Also. Pleased Need VBA Coding When I click Deskboard After Hide All other sheet Also = "Deskboard" Sheet is Trigger...

@how can I show a icon in Excel when I click on a Description column (Range (A15:A30) , if i will click after open Userform ? Icon Move After cell Selection. kindly Need VBA Coding

@ How to Get Period-wise Stock N3 =SUMIFS(E:E,C:C,L3,D:D,M3) ( IN) O3 =SUMIFS(J:J,H:H,L3,I:I,M3) (OUT)

Hi all, I'm pulling xml data from a folder using Power Bi Desktop. When I have expanded all the columns in PowerQuery, I get the following error message when trying to apply the query changes. The changes could not be saved to the server. Error returned: 'OLE DB or ODBC error...

All Question And Answer to save in "Sheet1) We Need Reference "Question" Sheet1 to Sheet 2 , Also need four Option reference data from Sheet 1 According Question Kindly make solution this query

My Formula Problem this above condition , Not show Proper Format We Need this Format Result : EXP/025/21-22 Kindly Correction Below Formula , and Show Perfect Formula in this case =LEFT("EXP",3)&"/"&MID(A2,5,3)&"/21-22" Help me !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I was try , 3 table marge but i was tried ...... i was remove this table , & make New table but this last Name Assign Problem ...... How make Running File Marge 3 table , Without loss Data...??? How to possible ??? Pleased Show me Step- by- Step.

Hi All, Just hoping someone maybe able to help, what I am trying to do is; I currently have two Queries; I need help to be able to 'fix' the data in Query1 and concatenate the data in Query2 as per below. Query 1 Query 2 NEW QUERY (Derived) a 1 a1 b 2 a2 3 a3 4 a4 5 a5...

Hi I have a file with data that I want to import to excel via power query. All data in the file are continuous measurements of three water meters, which means that the consumption per hour is always current readings minus the previous one. To complicate things further, you can also readings...