Chandeep, making my life easier 1 video at a time! This will save me a lot of time not having to constantly update PQs that pull from other employees updated docs!
@jerrydellasala7643
Жыл бұрын
Verry nice! I'd love to see a video going through the full M Code! I'll also mention that using the sample file, in the Queries & Connections pane of the workbook, you can Right Click on the query "ChangeTypeNoErrors" and select "Export Connection File" and save the function to typically the "C:\Users\USER\OneDrive\Documents\My Data Sources" directory, and then import it to a new file by going to Data -> Existing Connections (under Get & Transform Data), and Import it into a new Excel file. Note that it will be listed as "Query - ChangeTypeNoErrors", and will default to being Imported as a Table and fail if not changed to Connection Only and leave remnants of where the table load is specified.
@fb_brito
Жыл бұрын
BR - Muito bom, consegui aplicar nas minhas consultas e como o @jerrydellasala7643 sugeriu consegui exportar a conexão e importar como uma conexão existente. Awesome! Chandeep.
@SemogOlecram
Жыл бұрын
Nice video Chandeep. But we all want a video building the function with the complete steps explanation!
@raimundojs9547
Жыл бұрын
Awesome! Always reminding that I still don't know almost anything and that I need to keep studying. Thanks again!
@gauravguliani358
8 ай бұрын
Is this Performance Efficient? I mean editing the M-Code is so intuitive Remembering to use & create the use this this Custom Function in itself seems more hassle than valuable
@aahanavikram07
Жыл бұрын
Thanks for the custom code.. It will really help in daily digging into the file and search for the errors.. It's a night mare to to go in power query and look into the errors. Thanks a Ton 👍
@GoodlyChandeep
Жыл бұрын
Glad it will be useful!
@williamarthur4801
Жыл бұрын
As below (above?), Verry nice! I'd love to see a video going through the full M Code! As an aside, your videos have come a long way in production values since you first started, very swish. 😊😊
@GoodlyChandeep
Жыл бұрын
I have a talented video editor helping me look good on camera 😁
@syedaneesdurez8766
Жыл бұрын
Thanks a lot. You made life easy by providing this code. Appreciate...
@GoodlyChandeep
Жыл бұрын
Glad to hear that!
@davidfelipepenaguardiola1177
Жыл бұрын
Nice solution, Mr Chandeep. Thank you very much for sharing it with us🥰
@fouadhoblos3611
Жыл бұрын
Hello.. Is it possible to ask for a favor? Just the answer for one question: why writing Power Query M in the advanced editor when used in Excel (not sure if the same happens in Power BI) tends to be extremely slow? At time for a very simple code I had to wait several seconds to write one letter! I stopped using it because of that.. I buffered every list and table that are frequently referred, nothing fixed it.. I had a Core i5-3337u and 8 Gb of RAM.
@JUHILLAPSIWALA007
Жыл бұрын
In custom column, = if [customer Name] null then [customer Name] & " (" & [Shop No.] & ")" else [Shop No.] But I got errors in some rows bcz of alphanumeric data in [Shop No.] column So how could I correct this?
@garimajain4616
Жыл бұрын
I am getting this problem,Can you help to understand how you created this m code, i am a beginner and dont know m code...
@subhalakshmivijayakumar8340
Жыл бұрын
After parse JSON, it is giving me 6 different subtables for the single record....all those 6 subtables were having different columns and values...so when I am using table.fromcolumns(6 list names)...it is working without any duplication as per the expectations...but if any of list is null means the entire parent table is getting collapsed
@Dishita123
Жыл бұрын
Need to calculate Running average sales Feb is 2+1÷2 Mar is 3+2+1÷3 April is 4+3+2+1 ÷4 like this
@diegoacevedo9208
Жыл бұрын
Hello goodly i have a quesiton. Is there a option in power pívot to "selectedvalue"? I need to do relative references y measures like calculate. Thanks
@bmalasa
Жыл бұрын
Thanks for the wonderful and professional video. Where is the M code file?
Hi, i am trying to add a prefix to a all my headers, basically i have Sales manager, Date, Amount, Profit etc, i want 1_Sales Manager 2_Date 3_Amount 4_Profit The prefix would be combination of series of number from 1 and with delimeter "-" with the orginal text. Please let me what would be the possible solution to it, TIA
@rajup4970
Жыл бұрын
very informative... please explain the query Changetypenoerror...
@jawadahmadehssan6251
Жыл бұрын
Great function. Thanks Chandeep
@GoodlyChandeep
Жыл бұрын
Glad you like it !
@khurramkhan5328
Жыл бұрын
You are awesome Chandeep. 👌 👏 Thank u for this
@GoodlyChandeep
Жыл бұрын
My pleasure !
@dilip1able
Жыл бұрын
Nice trick Chandeep. What about if I add new fields?
@DeronHuskey
Жыл бұрын
Great work Chandeep!
@GoodlyChandeep
Жыл бұрын
Thank You !
@mirrrvelll5164
Жыл бұрын
Damn man! Great work! This is gonna be my usual fx from tomorrow on at the work ))
@GoodlyChandeep
Жыл бұрын
Cool !
@zahir585
Жыл бұрын
What a great tricks 😀 thank you my friend 🙌🏻
@GoodlyChandeep
Жыл бұрын
Thank you too!
@amar4753
Жыл бұрын
you are the Goat 🐐 of power query for me and please accept my honour 🙏
@GoodlyChandeep
Жыл бұрын
Thanks! Glad you think so!
@syrophenikan
10 ай бұрын
Great job!!!
@rakeshreddyreddy4477
Жыл бұрын
How to create date column when we are extracting data from Sql through direct query
@miguelmedina2867
Жыл бұрын
I can't download the file with the function
@FRANKWHITE1996
Жыл бұрын
thanks for sharing
@GoodlyChandeep
Жыл бұрын
You're welcome!
@NhiNgo-up8js
Ай бұрын
cool
@mcnater
Жыл бұрын
Great stuff thanks!
@GoodlyChandeep
Жыл бұрын
Glad you liked it!
@AlexTaskarataskar
Жыл бұрын
Great video. What if you change column name or add column in the source file? In this cases the function doesn't work or doesn't change the TYPE. Do do you have a solution for this? Many thx.
@GoodlyChandeep
Жыл бұрын
goodly.co.in/dynamic-data-types-power-query/
@terpstry
Жыл бұрын
Awesome!
@GoodlyChandeep
Жыл бұрын
Thanks!
@celestebenitez6688
Жыл бұрын
Can you attach the custom function to the description of this video?
@GoodlyChandeep
Жыл бұрын
Download from this link -- goodly.co.in/remove-change-type-errors-power-query/
@namangarg7875
Жыл бұрын
Sir plz xplain ISONAFTER function in DAX
@lionels839
Жыл бұрын
Dynamic please 😅
@yueyin6071
Жыл бұрын
Hi Goodly, thanks for this great video. I've create a function in Power Query and works pretty good in Power Query Editor form. But dont know why it can not be used as an DAX function for create measure columns
@mohitupadhayay1439
Жыл бұрын
Great video. I'd love to see a playlist for optimising reports and dax codes too.
@vaibhavthakur_1997
Жыл бұрын
Where to get that code ? Pls answer 🙏
@GoodlyChandeep
Жыл бұрын
pinned comment
@vaibhavthakur_1997
Жыл бұрын
@@GoodlyChandeep thanks brother 🙏
@ExcelWithChris
Жыл бұрын
How do I save a function so you can use it in any file? Cheers from South Africa
@GoodlyChandeep
Жыл бұрын
You'll have to create an extension using VS Code and save it along with installer files. I guess I'll have to make a video on that :)
@ExcelWithChris
Жыл бұрын
@@GoodlyChandeep That would be great! Maybe you also know how when you format Pivot tables, you sometimes duplicate a built in format and then change it, but it then also applies to the file. I create lots of files with pivot tables and customize them all, but then have to re-create the custom format in each file.
@manideepak6820
Жыл бұрын
@@GoodlyChandeep whether it work in other system If I share my file to any one who does not have custom formula
@GoodlyChandeep
Жыл бұрын
@@ExcelWithChris You can save custom formats for a pivot table in the following way In Excel go to FILE > OPTIONS > DATA > Edit Default Layout. Save your pivot format for once and stay happy every after :D
@ExcelWithChris
Жыл бұрын
@@GoodlyChandeep Thanks a million. Will create a custom layout, then click inside and then follow your steps. You are the best.
@sharonrubavathy5812
Жыл бұрын
Please help me in need of urgent help I am trying to do running total on non date column. I am trying to show it in a table visual. I have 18k rows. Following the dax, its working for me but takes some 20 minutes for loading the table visual. Can you help me in optimizing the measure or any other way to achieve running total faster. Not sure, why just for 18k rows of data, its taking too long to load the running sum measure. I am attaching the error and sample file below. Please help me out. If u drag the running sum measure into table visual, its taking too long to load drive.google.com/file/d/16B_PL6pYo4HmsyCILRmXJL0WIXt_NYsa/view?usp=share_link
Пікірлер: 66