Lineth Dela Cruz
Lineth Dela Cruz
  • Видео 135
  • Просмотров 345 850
Remove Empty Columns Automatically using Power Query Function
In this video, I will be sharing the function that I’ve created using power query to automatically delete empty columns in a table.
0:00 Intro
1:00 Function for Remove Empty Columns
3:59 Final checking & Outro
Watch the whole video for further explanation of the process!
Visit my channel: ruclips.net/user/LinethDelaCruz
Link to download the sample file:
www.dropbox.com/s/5ycoo3j9qz6ti29/PQFxRemoveEmptyCols1.xlsx?dl=0
Link on Playlist: Learn Spreadsheet Power Query: ruclips.net/video/7IILCyP_YBc/видео.html
Thanks for your time and I hope you learn something from it.
Help me to reach my target audience by sharing my videos with the right people.
Don’t forget to SUBSCRIBE!
Просмотров: 1 320

Видео

Combine Text from Different Rows into One Cell using Power Query
Просмотров 1,6 тыс.2 года назад
In this video, I will share with you a specific problem for combining text coming from different rows into one cell solved using the Power Query. 0:00 Intro 1:00 Group the Table 2:46 Further steps to Combine Texts 4:52 Final checking & Outro Watch the whole video for further explanation of the process! Visit my channel: ruclips.net/user/LinethDelaCruz Link to download the sample file: www.dropb...
Power Query Function for Bulk Renaming of Columns
Просмотров 6192 года назад
In this video, I will share with you the function that I’ve created to rename column names or headers in bulk using the Power Query. 0:00 Intro 0:48 Create the function in PQ 2:26 Test the function & outro Watch the whole video for further explanation of the process! Visit my channel: ruclips.net/user/LinethDelaCruz Link to download the sample file: www.dropbox.com/s/rf7v4ko7mbhji9g/PQfxRenameC...
Replicating SumProduct in Power Query
Просмотров 2,9 тыс.2 года назад
In this video, I will do two things in the Power Query. First is to replicate the SUMPRODUCT formula in Excel and second is to insert a new row using Table.InsertRows. 0:00 Intro & Sumproduct in Excel 1:12 Replicate Sumproduct in Advanced Editor 4:46 Insert new row with Table.InsertRows 6:56 Final checking & outro Watch the whole video for further explanation of the process! Visit my channel: r...
How to Add Leading Zeros in Excel Formula and Power Query
Просмотров 4612 года назад
In this video, I will show you how to add leading zeros in your data. I have three simple solutions for that. One is using the REPT & LEN functions in Excel. Second is the Text.Repeat and Text.Length in Power Query. And the third option is the Text.PadStart in the Power Query. 0:00 Intro & REPT LEN Solution 1:35 Text.Repeat Text.Length Solution 3:08 Text.PadStart Solution 4:21 Final checking & ...
How to Use Parameters in Power Query
Просмотров 2,4 тыс.2 года назад
In this video, I will show you how to use parameters in power query when filtering and/or sorting data, and changing sheets references. 0:00 Intro & Get Data from Excel Workbook 0:54 Use Parameters in Filtering 2:09 Use Parameters in Navigating into Sheet Names 3:32 Use Parameters in Sorting 5:00 Load to spreadsheet, checking, & outro Watch the whole video for further explanation of the process...
Aging of Receivables Report using Power Query
Просмотров 2,6 тыс.2 года назад
In this video, I am gonna do aging of receivables report using the power query. 0:00 Intro 0:37 Edit data and Add Age 1:00 Set reference table using fxPastDueDaysLabel function 1:25 Calculate past due days 2:23 Perform Approximate Match 4:33 Use try otherwise in Past Due column 5:16 Load into Pivot Table Report 5:57 Final checking and outro Watch the whole video for further explanation of the p...
Power Query List.Numbers Example turn into a Reference Table
Просмотров 1,1 тыс.2 года назад
In this video, I will show you one way of using List.Numbers as a reference table in an Aging of Receivables report. 0:00 Intro & List.Numbers 0:46 Make the list a reference table 4:35 Make a function 5:21 Test the function & Outro Watch the whole video for further explanation of the process! Visit my channel: ruclips.net/user/LinethDelaCruz Link to download the sample file: www.dropbox.com/s/k...
Power Query Fiscal Quarter Label Custom Function
Просмотров 4612 года назад
In this video, I will show you my created function for Fiscal Quarter label based on a given date and any start of fiscal period of your choice. 0:00 Intro 0:59 Put formula using Advanced Editor 4:18 Invoke the Function 4:53 Final checking & Outro Watch the whole video for further explanation of the process! Visit my channel: ruclips.net/user/LinethDelaCruz Link to download the sample file: www...
Power Query Fiscal Year Label Custom Function
Просмотров 1,3 тыс.2 года назад
In this video, I will show you my created function for Fiscal Year label based on a given date and any start of fiscal period of your choice. 0:00 Intro 0:43 Put formula using Advanced Editor 3:58 Load DATE example and Invoke the Function 4:58 Final checking & Outro Watch the whole video for further explanation of the process! Visit my channel: ruclips.net/user/LinethDelaCruz Link to download t...
How to Get the Applicable Rate with Approximate Match in Power Query
Просмотров 3952 года назад
In this video, I will show you how to get rate based on a graduated table that is usually solve using approximate match in Power Query. This can be applicable in getting different commission, bonus, or penalty rates based on the range of amount. 0:00 Intro & Load tables in PQ 1:04 LET function 1st variable 1:55 2nd variable with List.Select & List.Last 3:38 3rd variable with Table.SelectRows & ...
Power Query Time Range per Time Interval Template with List.Generate
Просмотров 3,1 тыс.2 года назад
Power Query Time Range per Time Interval Template with List.Generate
Create a List of Random Product Name using the List Generate in Power Query
Просмотров 6472 года назад
Create a List of Random Product Name using the List Generate in Power Query
How to Get the Maximum Sales per Product per Latest Entry Date with Power Query Table Buffer
Просмотров 8182 года назад
How to Get the Maximum Sales per Product per Latest Entry Date with Power Query Table Buffer
Get the Sales Contribution of each Promotion solved using Power Query
Просмотров 3692 года назад
Get the Sales Contribution of each Promotion solved using Power Query
Create Repeating Rows based on Trip Count and Distribute Budget per Trip in Power Query
Просмотров 1492 года назад
Create Repeating Rows based on Trip Count and Distribute Budget per Trip in Power Query
Get the List of Repeat Customer using the List Intersect in Power Query
Просмотров 8822 года назад
Get the List of Repeat Customer using the List Intersect in Power Query
Power Query List Difference to Get the List of New Data from Multiple Tables
Просмотров 1,1 тыс.2 года назад
Power Query List Difference to Get the List of New Data from Multiple Tables
Power Query Table Group and Text Split Formula Combined
Просмотров 3502 года назад
Power Query Table Group and Text Split Formula Combined
Assign Tasks Evenly to Team Members using Modulo in Power Query
Просмотров 3 тыс.2 года назад
Assign Tasks Evenly to Team Members using Modulo in Power Query
Power Query Text.PositionOf instead of using Search and Lookup Function in Excel
Просмотров 1,3 тыс.2 года назад
Power Query Text.PositionOf instead of using Search and Lookup Function in Excel
Power Query List Split with 2 Examples
Просмотров 3,2 тыс.2 года назад
Power Query List Split with 2 Examples
How to handle DUPLICATES when using Merge Queries Left Outer in Power Query
Просмотров 18 тыс.2 года назад
How to handle DUPLICATES when using Merge Queries Left Outer in Power Query
Power Query Average Unit Price based on the LAST N DAYS
Просмотров 9812 года назад
Power Query Average Unit Price based on the LAST N DAYS
Networkdays Template in Power Query
Просмотров 1,4 тыс.2 года назад
Networkdays Template in Power Query
Arranging Online Survey Data with Unpivot in Power Query and Pivot Table
Просмотров 4432 года назад
Arranging Online Survey Data with Unpivot in Power Query and Pivot Table
Power Query Get the Unique Combination of Two List
Просмотров 6762 года назад
Power Query Get the Unique Combination of Two List
Rename Multiple Column Names in Power Query
Просмотров 1,7 тыс.2 года назад
Rename Multiple Column Names in Power Query
Power Query Get the Weighted Average Unit Cost with Multiple Grouping
Просмотров 5 тыс.2 года назад
Power Query Get the Weighted Average Unit Cost with Multiple Grouping
Power Query List Accumulate for Running Total
Просмотров 4,8 тыс.2 года назад
Power Query List Accumulate for Running Total

Комментарии

  • @MandixYaborgi
    @MandixYaborgi 3 дня назад

    Cool

  • @m.s.am.s.a3283
    @m.s.am.s.a3283 5 дней назад

    the formula to make the project start day does not work with me. it gives me #name . how to fix this plz

  • @fuadfachrudin8907
    @fuadfachrudin8907 28 дней назад

    Thank you so much

  • @CrazyworldMotionDesigner
    @CrazyworldMotionDesigner 29 дней назад

    Nice 👍

  • @TheRajasekar03
    @TheRajasekar03 Месяц назад

    This video not clear please post again three way vlook ups

  • @TheRajasekar03
    @TheRajasekar03 Месяц назад

    Nice

  • @TheRajasekar03
    @TheRajasekar03 Месяц назад

    Cool formula

  • @TheRajasekar03
    @TheRajasekar03 Месяц назад

    It saves so much time

  • @haseebsheroz6137
    @haseebsheroz6137 Месяц назад

    Thank you so much

  • @kebincui
    @kebincui Месяц назад

    ❤👍

  • @mmmzzz77
    @mmmzzz77 2 месяца назад

    thank you very much... very useful

  • @subhrajyotichakraborty2613
    @subhrajyotichakraborty2613 2 месяца назад

    Hi Lineth what if we had quantity sold under three different heads like Shirt Type 1, Shirt Type 2 and Shirt Type 3. We also should be able to filter by shirt type along with days year and months. How de we handle this scenario?

  • @Malik-ix2kx
    @Malik-ix2kx 2 месяца назад

    very very helpful❤

  • @markfamulagan8320
    @markfamulagan8320 2 месяца назад

    Grabe ka paspas maam😢😢😢

  • @abdullah_alhathloul_
    @abdullah_alhathloul_ 2 месяца назад

    Nice

  • @hendrag593
    @hendrag593 2 месяца назад

    Thank you for this great video. It is well explained and easy to understand. GBU

  • @marufkarimov9942
    @marufkarimov9942 2 месяца назад

    qolum

  • @kebincui
    @kebincui 2 месяца назад

    The best video to illustrate the issue and solution with Table.Buffer 👍👍. Thank you so much ❤❤🌹🌹

  • @saichandu5965
    @saichandu5965 3 месяца назад

    wow been looking for this function....can we consider quarter based on any condition lets say i have downloadeddata for q3 butdate will be in q2....can we do it

  • @brightbello3818
    @brightbello3818 3 месяца назад

    Wow😂❤❤

  • @luisgarcia7534
    @luisgarcia7534 4 месяца назад

    Thank you very much

  • @TheRajasekar03
    @TheRajasekar03 4 месяца назад

    Hats off

  • @TheRajasekar03
    @TheRajasekar03 4 месяца назад

    Time saver

  • @TheRajasekar03
    @TheRajasekar03 4 месяца назад

    Nice

  • @TheRajasekar03
    @TheRajasekar03 4 месяца назад

    Really nice it is really useful

  • @MyatThinzarMonica
    @MyatThinzarMonica 4 месяца назад

    I cannot use this formula for completed progress in google sheet. How can I do? Please advise me. Thank you

  • @mayonalbay8516
    @mayonalbay8516 4 месяца назад

    HI PAANO KUNG HINDI MO ISAMA ANG WEEKEND LIKE SUNDAY? THANK YOU

  • @MyatThinzarMonica
    @MyatThinzarMonica 4 месяца назад

    I didn't see what you input in the custom field before insert the data bar.

  • @tommcc99
    @tommcc99 4 месяца назад

    Thank you. I have to search text strings (all different formats) in large transaction files for names, identify them by source (15 different and they change), give the out put a certain code and then sort by source. I have been using the if and search function and it is time consuming, and prone to error to update. This is a much better solution. You have saved me time and worry! Thank you for sharing this information!!

  • @tahermillwala9917
    @tahermillwala9917 5 месяцев назад

    Thank you very much, I am just looking to know how to use right function as text ❤❤❤

  • @jeannemarieenriquez5867
    @jeannemarieenriquez5867 5 месяцев назад

    What if the Product is Orange 1, Orange 2, Orange 3.. How do I get the sum for Orange 1 only?

  • @sadiabajwa5688
    @sadiabajwa5688 5 месяцев назад

    you are talking to yourself 🙄🙄

  • @MariaRamirez-zd3jy
    @MariaRamirez-zd3jy 5 месяцев назад

    thank you :)

  • @Forever_Young0212
    @Forever_Young0212 5 месяцев назад

    THANK YOU SOOOOOOO MUCHHHH!!!!

  • @mercadomarcos
    @mercadomarcos 6 месяцев назад

    Thank you for posting this. I used your solution in Power BI. It's tricky how you execute the function instead of the standard function calling.

  • @germanidrovo1002
    @germanidrovo1002 6 месяцев назад

    great video.. thanks

  • @ismapsan
    @ismapsan 6 месяцев назад

    Great Job! Saved me hours of manual work renaming columns! Thank you!!!

  • @fawazkolaposulaiman1925
    @fawazkolaposulaiman1925 7 месяцев назад

    This is so gooood Lineth. Marry me if you're not married. Just joking. Thank you it worked for me. Mmuah mmuah

  • @alexpr6869
    @alexpr6869 7 месяцев назад

    Thank you so much

  • @TuanAiir
    @TuanAiir 7 месяцев назад

    Many many thks!

  • @babai9277
    @babai9277 7 месяцев назад

    SumIFS bhi work karega

  • @willvanluven2769
    @willvanluven2769 7 месяцев назад

    Thanks! Very useful!

  • @kennethtansh7851
    @kennethtansh7851 7 месяцев назад

    How to did anchor on the task_start, task_end and progress? After clicking name manager, there is no option for anchoring

  • @user-en3pc7ko8e
    @user-en3pc7ko8e 7 месяцев назад

    superawesome!

  • @user-sj8gv2xf9y
    @user-sj8gv2xf9y 8 месяцев назад

    Super helpful po ma'am, thank you po. Merry Christmas. 🎉

  • @tbatchful
    @tbatchful 8 месяцев назад

    This video just saved me hours of manual work! Thank you!

  • @arghyadutta9091
    @arghyadutta9091 8 месяцев назад

    Great

  • @AymanWithAPlan
    @AymanWithAPlan 9 месяцев назад

    YOU ARE THE BEST! IVE BEEN TRYING TO DO THIS FOR TWO HOURS NONE OF THE OTHER VIDEOS HELPED!

  • @Akashpadhan
    @Akashpadhan 10 месяцев назад

    how to format if I want to search more than one text i.e K5:K10

  • @rrrraaaacccc80
    @rrrraaaacccc80 10 месяцев назад

    👍💯