Одну секунду
Что-то сучилось. Попробуйте еще раз.
Power query if or смотреть последние обновления за сегодня на .
Power Query if statements using the Power Query if function are easier to write than those in Excel. In this video I'll teach you how to write them in both Excel and Power BI using the Custom Column tool and write Power Query if and, if or, and nested if statements. 🔻 DOWNLOAD EXCEL FILE HERE: 🤍 🎓 LEARN MORE in my Power Query course: 🤍 🔔 SUBSCRIBE if you’d like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all! 🧟♀️ CONNECT with Mynda on LinkedIn: 🤍 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: 🤍 ⏲ TIMESTAMPS 0:00 How to write if Statements in Power Query 0:29 Power Query if statements with Conditional Column 1:42 Power Query if statements with Custom Column 2:29 Power Query if or statements 3:52 Power Query if and statements 4:53 Power Query nested if statements 6:27 File Download Link
Using the functions IF, AND, OR in Power Query is a little different to Excel. Sample Data sets 🤍 00:00 Intro 00:16 Sample Data Sets 01:20 Fixing US Date 02:23 IF 03:00 AND 04:32 OR Connect with me via the following link 🤍 Access Analytic 🤍
Learn how to write IF, Nested IF, And, Or function in Power Query using Conditional Column and Custom Column options. IF Function in Power Query The full tutorial and Excel files can be downloaded here - 🤍 - - - - My Courses - - - - ✔️ Mastering DAX in Power BI - 🤍 ✔️ Power Query Course- 🤍 ✔️ Master Excel Step by Step- 🤍 ✔️ Business Intelligence Dashboards- 🤍 - - - - Blog - - - - 🤍
In this video. I will show you how to create an IF OR and IF AND constructs in power query functions. ✅ Power Query Course Download files: 🤍 ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - 🤍 Free Excel Course (Basic to Advanced) - 🤍 Best Excel Books: 🤍 Subscribe to get awesome Excel Tips every week: 🤍 #Excel #PowerQuery #ExcelTips
Master the if function. Learn about its syntax, get if statement examples and understand what errors you can bump into. 0:00 Introduction 0:41 The data set 1:06 Your first if-statement 2:38 Differences with Excel 4:01 Using Conditional Column 8:45 Logical operators 9:18 Nested if-statements 13:45 Using multiple conditions 19:00 An alternative to OR 20:52 Errors in Power Query WRITTEN ARTICLE: 🤍 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. SUPPORT MY CHANNEL Any videos are made free of charge. You can support my channel by giving a donation through: 🤍 Website: 🤍 SUBSCRIBE TO MY CHANNEL 🤍 LET'S CONNECT: Blog: 🤍 Facebook: 🤍 Twitter: 🤍 LinkedIn: 🤍 Thank you for your support! #PowerQuery #IfFunction #BIGorilla
The IF function is one of the most useful in Excel. In this video we look at how to write an IF function in Power Query. The video includes three examples. Firstly a typical IF function added as a custom column. Then we combine the If function with Or logic. Then we finish we a nested IF example. The video will cover the key differences between writing formulas in Power Query and in worksheets. Find more great free tutorials at; 🤍 * Online Excel Courses * The Ultimate Excel Course – Learn Everything ► 🤍 Excel VBA for Beginners ► 🤍 Advanced Excel Tricks ► 🤍 Excel Formulas Made Easy ► 🤍 Creating Sports League Tables and Tournaments in Excel ► 🤍 Connect with us! LinkedIn ► 🤍 Instagram ► 🤍 Twitter ► 🤍
As the title says, in this video I will show you how to write if-statements like a pro: Chapters 00:00 The ultimate if-statement 00:40 if statement in Excel wont work 01:50 Use power query user interface to write if statement 03:00 Nested if-statements 03:38 AND/OR conditions in if statements 04:48 NOT condition in if statements 05:20 Manage errors in if statements 06:13 Advanced if statements 08:19 Order of evaluation if statements Done! Here you can download all the pbix files: 🤍 SUBSCRIBE to learn more about Power and Excel BI! 🤍 Our PLAYLISTS: - Join our DAX Fridays! Series: 🤍 - Power BI dashboards for beginners: 🤍 - Power BI Tips & Tricks: 🤍 - Power Bi and Google Analytics: 🤍 ☼☼☼☼☼☼☼☼☼☼ POWER BI COURSES: Want to learn Power BI? How about you take one of our courses? Here you can find the available courses: 🤍 ☼☼☼☼☼☼☼☼☼☼ ABOUT CURBAL: Website: 🤍 Contact us: 🤍 ▼▼▼▼▼▼▼▼▼▼ If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running: 🤍 Many thanks in advance! ▲▲▲▲▲▲▲▲▲▲ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► 🤍 Twitter ► 🤍curbalen, 🤍ruthpozuelo Facebook ► 🤍 #CURBAL #SUBSCRIBE
⏬ Click to check out the description for info and links⏬ I show 2 methods to write a multiple IF formula in Power Query including using an "Approximate Match" method 00:00 Intro 00:34 The Setup and Goal 01:24 A better way of writing a nested IF 06:54 How to do an Approximate Match in Power Query Download the file 🤍 Did you know I've written a book "Power BI for the Excel Analyst"? 🤍 Connect with me 🤍 🤍
Have you come across Value.Is ? You can you use to replicate the Excel function IF ( ISNUMBER Did you know we run training in Perth, Australia and surrounding regions? 🤍 Did you know I've written a beginners guide to Power BI "Power BI for the Excel Analyst"? 🤍 Connect with me 🤍 🤍
This is my solution to creating a nested if/and/or statement when adding a column in Power Query in Power BI. I created this video in response to a request from Mr. Jaidev Solanki as part of the Maven Analytics monthly data challenge, which involved looking at cleaning up to 28 million lines of NYC taxi journey data. Original Data Cleaning Video: 🤍 Final Product Video: 🤍 YT Subscribe: 🤍 Blog: 🤍
Power Query's conditional columns are super easy but they cannot work with comparing relative dates, you need custom code for that, but once you understand it there are dozens of date functions in Power Query. Remember to Wrap Date.From() around our functions to explicitly set the date format and always use upper case. If you want a copy of this workbook, leave me a comment & subscribe to my channel. Learn all date functions here: 🤍 Functions I showcase: Today: Date.From(DateTime.LocalNow()) One quarter ago: Date.From(Date.AddQuarters(DateTime.LocalNow(),-1)) End of last month: Date.From(Date.EndOfMonth(DateTime.LocalNow())) 00:00 - Introduction 02:43 - Before today 05:55 - Before one quarter ago 08:44 - End of last month 10:38 - Filtering based on a relative date 11:54 - Date functions documentation
In this short video, I'll begin by outlining the origins of the If Statement in Programming within a Slide. After that I showcase the range of mathematical operators available in Power Query, so that you can power up your transformations. We'll then move into the Power Query editor and I'll demonstrate the if function in the following formats: - As part of a Conditional Column & the drawbacks to this approach - As part of a Custom Column with the key syntax structure - Powering up the if function with and, or & if not - Combining if with other Power Query M functions, such as Text.Contains & List.Contains Enjoy! 🤝 Connect with me on LinkedIn: 🤍 🤝 View my Website: 🤍 Please Like, Subscribe, Comment & Share if you enjoy!
IF functions can get complex, between two dates, text containing etc. and if they have multiple criteria referring to multiple columns the functions very long. Excel has a little known trick to avoid this. A conditional column within Power Query allows a super-easy way to do the most complex of IF statements without writing a simple formula. Power Query is the biggest thing to have happened to Excel in 25 years, and the Conditional Column is one great way to test it out. As this is a Power Query tool it can also be replicated in Power BI Here is my Power Query intro video & comparison with Power BI and Power Pivot: 🤍 Download Power Query for Excel 2010/2013: 🤍 00:00 - Introduction 00:27 - Launch Power Query 00:59 - Conditional column 01:55 - Possible issues 02:59 - Refresh data
Use try .. otherwise to trap and deal with errors in Power Query. Download the Excel file here: 🤍 00:18 Introduction to try .. otherwise 01:08 Using Remove Errors and Replace Errors 01:33 Using try to Check for Errors 01:50 Examining the Contents of Error Records 03:20 A Fast Way to Access Error Contents Using try 04:54 Using try .. otherwise to Replace Calculation Errors With a Default Value 06:02 Dealing With Errors Caused by a Missing Data Source View my comprehensive courses: 🤍 Connect with me on LinkedIn: 🤍
En este video vemos como usar el tipo de dato, es decir como especifico si el dato es por ejemplo un numero en power query, y lo deseo usar como argumento de una función lógica if o combinar el if con un and o un or. Las funciones lógicas if son lo relativo en excel a la función si. Función si en power query. Curso de Power Query: 🤍
In today's video i will show you one technique for conditional merging tables in Power Query. I forgot to mention the source of the video: 🤍 Links to mentioned resources: Joins in Power query: 🤍 Download the sample file number 67 at the community downloads here: 🤍 SUBSCRIBE to learn more about Power and Excel BI! 🤍 Our PLAYLISTS: - Join our DAX Fridays! Series: 🤍 - Power BI dashboards for beginners: 🤍 - Power BI Tips & Tricks: 🤍 - Power Bi and Google Analytics: 🤍 ☼☼☼☼☼☼☼☼☼☼ POWER BI COURSES: Want to learn Power BI? How about you take one of our courses? Here you can find the available courses: 🤍 ☼☼☼☼☼☼☼☼☼☼ ABOUT CURBAL: Website: 🤍 Contact us: 🤍 ▼▼▼▼▼▼▼▼▼▼ If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running: 🤍 Many thanks in advance! ▲▲▲▲▲▲▲▲▲▲ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► 🤍 Twitter ► 🤍curbalen, 🤍ruthpozuelo Facebook ► 🤍 #CURBAL #SUBSCRIBE
Excel Power Query - Conditional Column
- - - - My Courses - - - - ✔️ Mastering DAX in Power BI - 🤍 ✔️ Power Query Course- 🤍 ✔️ Master Excel Step by Step- 🤍 ✔️ Business Intelligence Dashboards- 🤍 - - - - Blog - - - - 🤍 Articles 🤍 🤍 - ► Artist Attribution Music By: "After The Fall" Track Name: "Tears Of Gaia" Published by: Chill Out Records - Source: 🤍 Official After The Fall YouTube Channel Below 🤍 License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) Full license here: 🤍
In this video were going to cover how you can write your own if statements in Power Query. We cover how you can create one using conditional columns, or write your own using the formula bar. - 🚩 Get Demo Files here 🤍 👍 Become a Patreon to support the channel and get free perks! 🤍 🛍 Get exclusive templates built using best practices here 🤍 🤍 ❤ Other ways to support 🤍 GET IN TOUCH 📺 Website - 🤍solutionsabroad.co.uk 🤵 LinkedIn - 🤍 📘 Facebook - 🤍 🌍 WHO IS SOLUTIONS ABROAD Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube. If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you. 🐎 First, watch this video about how a typical Power BI workflow looks like 🤍 🗺 Learn DAX to extend your Power BI calculations 🤍 📆 Stay up-to-date on all the features Power BI releases monthly 🤍 🧪 Get certified as a Microsoft Data Analyst Associate 🤍 💡 Learn Power BI Features to improve your dashboards 🤍 📊 WHAT IS POWER BI? Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more. 🔻 Get started with Power BI Desktop for FREE 🤍 #PowerBI #DataAnalytics #BusinessIntelligence
This thing with how Power Query handles nulls, blanks or empty drove me nuts when I was a beginner and still today I manage to forget about it, so here is a video for how to manage them in case you struggle also with it. In this video, I will show you how to to is blank in power query. If you are trying to do fill down with empties or nulls, check this video instead: 🤍 Here you can download all the pbix files: 🤍 SUBSCRIBE to learn more about Power and Excel BI! 🤍 Our PLAYLISTS: - Join our DAX Fridays! Series: 🤍 - Power BI dashboards for beginners: 🤍 - Power BI Tips & Tricks: 🤍 - Power Bi and Google Analytics: 🤍 ☼☼☼☼☼☼☼☼☼☼ POWER BI COURSES: Want to learn Power BI? How about you take one of our courses? Here you can find the available courses: 🤍 ☼☼☼☼☼☼☼☼☼☼ ABOUT CURBAL: Website: 🤍 Contact us: 🤍 QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► 🤍 Twitter ► 🤍curbalen, 🤍ruthpozuelo Facebook ► 🤍
Usa il codice MENO10 per avere il 10% di sconto su #Xcamp, il corso pratico per imparare davvero Excel: 🤍 Vuoi imparare ad utilizzare al meglio POWER QUERY su Excel? Facile! Tutti i tutorial li trovate nella Playlist EXCEL Power Query - #EXCELoltreognilimite (🤍 In questo video tutorial facciamo una panoramica sul funzionamento delle #ColonneCondizionali in #PowerQuery. Cosa sono? In sintesi significa inserire un campo che restituisce il risultato sulla base della verifica di uno o più condizioni . Quello che in #Excel potremmo fare con la funzione SE() e gli operatori E() e O(). Vedremo come in #PowerQuery nei casi più semplici sia sufficiente utilizzare il comando Aggiungi Colonna condizionale. Quando però sono presenti più criteri che si devono verificare contemporaneamente o alternativamente potrebbe essere necessario scrivere la formula utilizzando le funzioni if ... then ... else e gli operativi and e or. Puoi scaricare il file Excel utilizzato in questo video se sei abbonato al canale o hai acquistato il corso pratico di Xcamp: 🤍 Utilizza il modulo di contatto su 🤍 per fornirci i tuoi dati e ti abiliteremo al download. Grazie! Grazie a tutti per il supporto! Lasciate un commento se vi va! :) e soprattutto ISCRIVETEVI al canale per non perdervi i prossimi trucchi!!! Sostieni il nostro canale con una donazione 🤍 Ecco alcuni titoli interessanti: ITA - Mi chiamo Excel risolvo i problemi (flessibile) 🤍 ITA - Mi chiamo Excel risolvo i problemi (kindle) 🤍 ENG - Power Pivot and Power BI: The Excel User's Guide to DAX 🤍 ENG - The Definitive Guide to DAX 🤍 ENG - Analyzing Data with Power BI and Power Pivot for Excel 🤍 ENG - Power Query for Power BI and Excel 🤍 ENG – dal 17/05/2022 – Excel 365 Bible 🤍 #EXCELoltreognilimite #EXCELoltreognilimiteTRUCCHIeSEGRETI #EXCELPowerQuery #emmanuelevietti autore: Emmanuele Vietti Video realizzato con: Camtasia Studio v.9.2.1 Software: Microsoft 365 Excel all rights reserved: © 2022 Experta Business Solutions srl ATTREZZATURA: Microsoft 365 Family - 🤍 Microsoft 365 Business - 🤍 Webcam - 🤍 Supporto webcam - 🤍 Luci led da tavolo - 🤍 Green screen - 🤍 Green screen e luci - 🤍 Tavoletta grafica - 🤍 LINKEDIN: Gruppo Utilizzo professionale di Microsoft Excel (🤍 FACEBOOK: Pagina Utilizzo professionale di Microsoft Excel (🤍 TELEGRAM: Gruppo Utilizzo professionale di Microsoft Office (🤍 TIKTOK: Profilo upmsexcel (🤍 INSTAGRAM: Profilo upmsexcel (🤍 Se questo video vi è piaciuto mettete un «mi piace», date uno sguardo agli altri contenuti ed iscrivetevi al nostro canale. Se avete suggerimenti su nuovi contributi da realizzare, inseriteli nella sezione commenti oppure compilate il modulo contatti sul nostro sito 🤍experta-bs.it e cercheremo di soddisfare le vostre richieste. La vostra soddisfazione: il nostro miglior risultato.
IF THIS, THEN THAT. Say hello to the IF statement in Power Query. In this video, I’ll show you how to create a custom column in Power Query with the IF statement. This is a lot easier than the regular IF statement in Excel, which can get quite complicated especially if you have multiple conditions and nested IF statements. If you enjoyed this video, please like and subscribe to my channel. Also, if you have any tutorial requests, leave a comment below! 🤍
- - - - My Courses - - - - ✔️ Mastering DAX in Power BI - 🤍 ✔️ Power Query Course- 🤍 ✔️ Master Excel Step by Step- 🤍 ✔️ Business Intelligence Dashboards- 🤍 - - - - SUMIF Old Video - - - - SUMIF using group by - 🤍 - - - - Blog - - - - 🤍
In this Free Excel Tutorial we are learning a simple line of VBA code that will automatically refresh Pivot Table report and Power Query Connections every time source data changes in Excel worksheet. Its quite a task if you have refresh pivot tables manually every time after making changes to source data range. But you can automate the whole refresh process by knowing just one line of code in Visual Basic. !! Get FREE Excel CORE BOOK: 🤍 [] For more Excel lessons and tutorials visit: 🤍 #AutoRefresh #PivotTable #PowerQuery
Want to know how to remove line breaks using PowerQuery in Excel? Here's another question: Do you know what a Line Break is called in M Code? I got this question recently after showing off how to break apart multi-row cells by using text to columns and placing a line break (Ctrl + J) as the delimiter. The question was - how do you do this in PowerQuery? Well, turns out it's really easy if you know where to look! In M (PowerQuery code) a line break is called a Line Feed and you need only go to split columns by delimiter, and choose line feed as the special character to use. Give it a try! #excel #nomouseclub #powerquery #shorts Follow for Excel tips, tricks and more! 🌍 Want to get moving faster in Excel? Take my 7 Days to Excel Challenge and level up today: 🤍 📚 Grab my FREE Excel for Professionals Ultimate Guide full of my 100+ of my favorite Shortcuts and Functions: 🤍 👉 Connect with me on social! Linkedin: 🤍 Tiktok: 🤍
If you get this error: DataSource.NotFound: File or Folder: We couldn't find the folder. To fix it: Update Excel Power Query File or Folder Path with Data Source Settings in Data Ribbon Tab, Get & Transform Data group, Data Source Settings option. Import Text Files Using Power Query. Power Query Error. Download did not complete. Power Query Error. Data Could Not Be Loaded. File Path Error in Power Query. Folder Path Error in Power Query. How to Update in Power Query. Refresh Data Error in Power Query. I get an error when I refresh in Power Query. Data Source Not Found Power Query Error. Need help with Data Source Not Found Error in Power Query.
#excel #powerquery #exceltutorial #msexcel Website: 🤍aaa-power.net Chapters: 0:00 Intro 2:22 handle errors using try .. otherwsie 4:00 handle errors using if .. then .. else 6:05 close To watch the full playlist 🤍 To download the working files: 🤍 To subscribe: 🤍 To follow on Facebook 🤍 To follow on LinkedIn: 🤍
Remove all rows having all null values in Query Table in Power Query in Power BI
In this video I show you how to do a conditional join in Power Query. Instead of using the merge feature from the ribbon I use an alternative way of joining two tables and compare it to a normal merge. Download link: 🤍 📊 TRAININGS 📊 - Learning Path 🤍 For Custom Trainings and Consulting email directly support🤍datatraining.io - ⏱️ TIMESTAMPS ⏱️ - 0:00 Intro 0:31 Example 1:22 Creating a list 03:07 Filtering a list using List.Select 5:36 Using a filtered list to perform a conditional join 7:00 Fuzzy Match instead of a conditional join 08:47 End - 😍 JOIN 😍 Subscribe: 🤍 Website: 🤍 Facebook: 🤍 LinkedIn: 🤍 Insta: 🤍 Twitter: 🤍 - 👇 CHECK THIS OUT! 👇 - 💻 My gear 🤍 📚 Power BI books MUST READ! 🤍 💡 General books I recommend 🤍 🎶 Music for my videos 🤍 🚀 For growing on YouTube: 🤍 🏄 Stuff I use daily 🤍 * Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos! Thanks for being a part of this channel and all your support! 💪 🙏 #HowToPowerBI #PowerBI #DataTraining #powerbidesktop #powerbitraining #powerbideveloper
We have usually said that if you use a native query, you break query folding in Power Query. Interesting. There may be a way to enable it in Power BI! Patrick shows you how. Chris Webb Blog: 🤍 Query folding guidance in Power BI Desktop 🤍 Visualise your Power BI Refresh 🤍 📢 Become a member: 🤍 * Want to take your Power BI skills to the next level? We have training courses available to help you with your journey. 🎓 Guy in a Cube courses: 🤍 * LET'S CONNECT! * 🤍 🤍 🤍 🤍 🤍 🤍 *Gear* 🛠 Check out my Tools page - 🤍 #PowerBI #PowerQuery #GuyInACube
I have shown you before how to filter a table by its most recent record before, but I have found a cleaner and I think more effective way to do it. (Tests both versions to see what works with your data) Here is the link to the previous video: 🤍 Get download 67 from the Curbal download center: 🤍 SUBSCRIBE to learn more about Power and Excel BI! 🤍 Our PLAYLISTS: - Join our DAX Fridays! Series: 🤍 - Power BI dashboards for beginners: 🤍 - Power BI Tips & Tricks: 🤍 - Power Bi and Google Analytics: 🤍 ☼☼☼☼☼☼☼☼☼☼ POWER BI COURSES: Want to learn Power BI? How about you take one of our courses? Here you can find the available courses: 🤍 ☼☼☼☼☼☼☼☼☼☼ ABOUT CURBAL: Website: 🤍 Contact us: 🤍 MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too! COUPON: CURBAL10 Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance! QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► 🤍 Twitter ► 🤍curbalen, 🤍ruthpozuelo Facebook ► 🤍 #CURBAL #SUBSCRIBE
It's more efficient for Excel to add columns for your fiscal periods with Power Query than it is with formulas. In this video I'll cover both fiscal periods that start at the beginning of a month and those, like a 4-5-4 calendar, that don’t. Download the Excel file here: 🤍 Learn Power Query: 🤍 View my comprehensive courses: 🤍 Connect with me on LinkedIn: 🤍
This video shows how you can create a condition to check for multiple substrings in a string. In other words to test if a value contains any of multiple items. It is very similar to the Text.Contains function, with the main difference that the shown methods are able to deal with multiple substrings. It's like a Text.ContainAny function to check if text contains one of many strings. If you need to perform an exact match, check out my other video: 🤍 Chapters: 0:00 Intro 0:22 Recap: exact match 0:56 Method 1: Splitter.SplitTextByAnyDelimiter 4:01 The issue with Text.Contains 4:50 Method 2: Leverage Text.Contains in a function ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. SUPPORT MY CHANNEL Any videos are made free of charge. You can support my channel by giving a donation through: 🤍 Website: 🤍 SUBSCRIBE TO MY CHANNEL 🤍 LET'S CONNECT: Blog: 🤍 Facebook: 🤍 Twitter: 🤍 LinkedIn: 🤍 Thank you for your support! #TextContains #PowerQuery #BIGorilla
Learn how to easily compare 3 or more tables in Power Query and avoid having to do lots of complicated query merges. 0:33 Power Query Lists (Table Columns) 1:02 Checking Source Data 1:30 Load Table Into Power Query (Connection Only) 2:30 Using #shared to Create Function Reference Table 3:20 List.Intersect 4:28 Filtering Table Using Table.SelectRows and List.ContainsAny 6:33 List.Union 8:13 List.Difference Download the Excel file that includes the data and queries in this video: 🤍 View my comprehensive courses: 🤍 Connect with me on LinkedIn: 🤍
Most often data is scattered in several Excel worksheets and to process the data, the daunting task is to first combine all the data in worksheets into one. Excel users had several workarounds to get this done, however, it was still painfully slow or complex at best. However, with the introduction of Excel Power Query, this is not the case anymore. With Excel Power Query, we can easily consolidate data from multiple worksheets by combining all of them in few simple steps. Once done, we have the dynamically updatable result that can even change if the source data changes. Lets Excel! For more Excel tips, tricks and tutorials don't forget to subscribe to 🤍Learn Excel to excel YT channel. Learn #Excel your way: = Website: 🤍 Pick your favourite social page: Fb: 🤍 Tiktok: 🤍 Tw: 🤍 Pin: 🤍 Yt: 🤍 Insta: 🤍 Music by: 🤍 #excelpayroll #exceltutorial #exceltips
This video teaches how you can replace values based on a condition. All in a single step! You can for example replace all negative numbers by 0, and leave the remaining numbers untouched. In addition, this method allows you to easily replace values based on another column. WRITTEN BLOGPOST: The ultimate guide to replacing values in Power Query, find it here: 🤍 If you want to learn how to do this for multiple columns, check out my other video: 🤍 Chapters: 00:00 Introduction 00:16 The dataset 00:40 Creating a temporary helper column 01:21 Replace values based on a condition ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. SUPPORT MY CHANNEL Any videos are made free of charge. You can support my channel by giving a donation through: 🤍 Website: 🤍 SUBSCRIBE TO MY CHANNEL 🤍 LET'S CONNECT: Blog: 🤍 Facebook: 🤍 Twitter: 🤍 LinkedIn: 🤍 Thank you for your support! #ConditionalReplace #PowerQuery #BIGorilla
Заготовка файла excel - 🤍 #Power Query #Power BI # Анализ данных #Excel #Обработка данных #Таблицы #Автоматизация #Графики #Визуализация #Диаграммы # Dashboard # IF # Условный столбец
In this post you learn how to retrieve a value from Grouped data in Power Query. It allows you to group your data and keep valuable information that would otherwise be lost. WRITTEN ARTICLE: 🤍 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. SUPPORT MY CHANNEL Any videos are made free of charge. You can support my channel by giving a donation through: 🤍 SUBSCRIBE TO MY CHANNEL 🤍 LET'S CONNECT: Blog: 🤍 Facebook: 🤍 Twitter: 🤍 LinkedIn: 🤍 Thank you for your support! #PowerQuery #TableMax#BIGorilla
Looking for the IN Operator equivalent in Power Query? This video shows you exactly what you need. WRITTEN ARTICLE: 🤍 CONTENT 00:00 Introduction 01:41 IN operator single column 03:54 Reference Table Values 05:34 IN Operator multiple columns ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: 🤍 SUBSCRIBE TO MY CHANNEL 🤍 LET'S CONNECT: Blog: 🤍 Facebook: 🤍 Twitter: 🤍 LinkedIn: 🤍 Thank you for your support! #INoperator #powerquery #bigorilla
.svg){kind=small}
