Відео

This is amazing yar Pawan 😂 Amazing

rubbish - where is the AI?

7:58:03

Assistance Needed with Power Query Error I have a folder named BankStatPDF that contains one Excel file named ConsolBS and two PDF bank statements named BankStatementMay and BankStatementJune. I transformed the BankStatementJune PDF file using Power Query in the ConsolBS worksheet, and it worked perfectly. However, when I changed the source file from BankStatementJune to BankStatementMay, I encountered the following error: Expression.Error: The key didn't match any rows in the table. Details: Key= Id=Table001 Table=[Table] Note: The PDF file BankStatementJune has 9 pages, so it was converted into 7 tables in Power Query. The PDF file BankStatementMay has only 3 pages. The format and bank statement details are the same for both files, and they are from the same bank. The Power Query editor has created 7 query tables of these 9 pages for BankStatementJune. I appended them into a new query named "Statement," so I now have a total of 8 queries. All of these 7 query tables showing the same error except the "Statement" query, which displays: An error occurred in the ‘Table001 (Page 2)’ query. Expression.Error: The key didn't match any rows in the table. Details: Key= Id=Table001 Table=[Table] Please guide me on how to fix this error. Note: The PDF file BankStatementJune is used to transform data in power query that has 9pages so it converted into 7tables. The PDF file BankStatementMay have only 3pages. rest the format and bank statement are same and of one bank. Thank you for your assistance.

Next level ...😮

So people without coding knowledge are lame!?

Pawan Sir you are awsome, your way of teaching is really Amazing...

8:45

I hardly comment on any video. But you are just amazing. You just simply blasted the way of delivering the content.🎉 Awesome...Google sheet rocks...😅

6:37:16

Yup like company hesitate to send data to openai, while Microsoft doesn't even ask 🤣🤣🤣

Powder zyada ho sir face pe.... 😂

Where is sample superstore

sir u deserve many thanks..

I am not getting the format option in my desktop aap

Awesome and many thanks.

what can i do if the %of grand total option is not showing in the power bi ?

Drill through and Filter on all pages are almost same. Isn't it?

How to share to LinkedIn

Sir, is there any class adavance excels?

Excellent

sir the link shared by you in the des. its a blank spreadsheet

This is such a great help - thank you! :)

Pavan Sir , You are the amazing … Hatss Off 🙌🏻

Thanks for the session.

There is no fields column in my powerbi. How can i access that?

Excellent work sir....

ctrl + / is the shortcut to create chart

How to install(get) Copilot in excel as I am not able to get it using Add ins

Who came here after Learn With Giggs LinkedIn Post about this video : Create Power BI Report in 7 mins

Sir , how we can change the color to filtered column which is inheriting color from first graph. Normal format column color change is not working because we have selected legend as Region. Could you please guide on this .

It was really very informative

I am not getting the panes as mentioned by you in the video

I'm unable to download the files, please help out

hi how to add total count to the bar chart ,without creating a separate table for it. With your help i created a dashboard where data is extracted from 15 different SharePoint sites, so when i create a bar chart its not showing total count as a separate bar along with other category, would you please help to do this. Example in above video u have a bar chart which states each category but it does not have the total right, I want a total to be added over there

Hi Sir, Actually I have created a stacked bar chart but horizontal gridlines are not off when I have disable the button so what can I do

Ctrl + E Was a magic. Thanks

Great Teacher😊

Excellent sir

Sir this sample report file can we download for practice

Hi Pawan Will you come up with "Power App" course in near future?

ua-cam.com/users/shortslI-uHnqHgN8?si=UMouBQ2uoI8N5nl3

god level explanation

Hi i need your template to create power bi

Just completed this Course and I can without any doubt this is the Best I have ever learnt. Simply amazing

Hats Off to you for this Excellent Video❤❤

Pavan bhai you are a Hero❤

Awesome Bro, Thanks have seen a lot of videos this was the best kudos 😊

HELLO SIR, what app to use recording youtube video, tell me sir

Sir Data modeling and Dax missing.. If possible, please create a video on it.