#powerquery 搜尋結果

Combine and Expand Tricks in #PowerQuery


Dynamically Remove null rows in #PowerQuery {M}joy

chandeep2786's tweet image. Dynamically Remove null rows in #PowerQuery
{M}joy

YT Video Ready !! SEE YOUU TOMORROW 6PM !! #Freedomanalytics #excel #powerquery #excelmagic

ObohX's tweet image. YT Video Ready !! 

SEE  YOUU TOMORROW 6PM !! 

#Freedomanalytics #excel #powerquery #excelmagic

How many of these #PowerQuery tricks do you know?


Ever had a #PowerQuery load fail after a new column shows up in your CSV file? Sometimes PQ locks the column count when you 1st import a file. When the data source adds new fields, it breaks the connection. The fix? Delete the hardcoded column count argument in the formula bar!

kpuls's tweet image. Ever had a #PowerQuery load fail after a new column shows up in your CSV file? Sometimes PQ locks the column count when you 1st import a file. When the data source adds new fields, it breaks the connection. The fix? Delete the hardcoded column count argument in the formula bar!

مشروعي الأول في عالم تحليل البيانات فخور بمشاركتي أول مشروع داشبورد تفاعلي أشتغلت عليه باستخدام Excel ضمن دورة تحليل البيانات المقدمة من معسكر SPARK - جامعة الملك خالد كلية الهندسة @AlomairAbdulDS #تحليل_البيانات #Excel #PowerQuery #SPARK_KKU #DataAnalytics

Ok9Fo's tweet image. مشروعي الأول في عالم تحليل البيانات
فخور بمشاركتي أول مشروع داشبورد تفاعلي أشتغلت عليه باستخدام Excel ضمن دورة تحليل البيانات المقدمة من معسكر SPARK - جامعة الملك خالد  كلية الهندسة @AlomairAbdulDS 
#تحليل_البيانات  #Excel
 #PowerQuery #SPARK_KKU #DataAnalytics

While performing Grouping in Power Query, you might want to concatenate the values instead of summarizing them. For all those times, here is a neat trick ✌️. I’ve covered many more tips and tricks like this in my #PowerQuery book, Grab your copy here - products.goodly.co.in/power-query-bo…

chandeep2786's tweet image. While performing Grouping in Power Query, you might want to concatenate the values instead of summarizing them.

For all those times, here is a neat trick ✌️.

I’ve covered many more tips and tricks like this in my #PowerQuery book,
Grab your copy here - products.goodly.co.in/power-query-bo……

Web scraping? Power Query does that too. In today’s video, I’m showing you how to clean, transform & automate your data workflows with Power Query in Excel, from CSVs to web data. Drops today by 6PM Subscribe so you don’t miss it: 🔗 youtube.com/@ObohYT #Excel #PowerQuery


How to make shorter queries in #PowerQuery #MJoy


Instead of scrolling sideways to check columns, click the row header and view the whole row as a record. It’s a much easier way to look at wide tables in #PowerQuery.


How to make your Power Query Case Insensitive 🤔 The Compare Case enumeration (keyword) is available for - - Text.Contains - Text.StartsWith - Text.EndsWith - And a few others #Mjoy #PowerQuery


Hey #DataFam 🫢 A 4-Year January Sales Overview (2018–2021) filtered by business segment. From Power Query ➡️ Power Pivot ➡️ DAX ➡️ Pivot Tables = Excel magic. No VBA. No add-ins. Just pure Excel. Thanks y’all for the support always 🫶❤️ #Excel #PowerQuery #DAX #Dashboard

ObohX's tweet image. Hey #DataFam 🫢

A 4-Year January Sales Overview (2018–2021) filtered by business segment.

From Power Query ➡️ Power Pivot ➡️ DAX ➡️ Pivot Tables = Excel magic.
No VBA. No add-ins. Just pure Excel.

Thanks y’all for the support always 🫶❤️

#Excel #PowerQuery #DAX #Dashboard

Navigating through extensive tables in #PowerQuery can be quite challenging, right? Instead of getting lost in the sea of columns, try pressing CTRL + G to jump directly to the column you're looking for. Hope this tip helps! 😉 Black Friday Sale 🎉 - products.goodly.co.in/learn-m-powerq…


How to Clean up special characters in #powerQuery .... Follow for more tips .... #Excel


I had a great time today leading a masterclass as part of #BulgariaExcelDays on the awesomeness of #PowerQuery! If you spend time manually gathering, cleaning and transforming data, you know how tedious it can be. PQ will change your work forever, saving hours of time & effort.😎

kpuls's tweet image. I had a great time today leading a masterclass as part of #BulgariaExcelDays on the awesomeness of #PowerQuery! If you spend time manually gathering, cleaning and transforming data, you know how tedious it can be. PQ will change your work forever, saving hours of time & effort.😎
kpuls's tweet image. I had a great time today leading a masterclass as part of #BulgariaExcelDays on the awesomeness of #PowerQuery! If you spend time manually gathering, cleaning and transforming data, you know how tedious it can be. PQ will change your work forever, saving hours of time & effort.😎
kpuls's tweet image. I had a great time today leading a masterclass as part of #BulgariaExcelDays on the awesomeness of #PowerQuery! If you spend time manually gathering, cleaning and transforming data, you know how tedious it can be. PQ will change your work forever, saving hours of time & effort.😎

動作確認できていないのですが、これでどうでしょうか? Date.ToText( #date(2025,12,3), "yyyymm" ) #Excel #PowerQuery


Ever had a #PowerQuery load fail after a new column shows up in your CSV file? Sometimes PQ locks the column count when you 1st import a file. When the data source adds new fields, it breaks the connection. The fix? Delete the hardcoded column count argument in the formula bar!

kpuls's tweet image. Ever had a #PowerQuery load fail after a new column shows up in your CSV file? Sometimes PQ locks the column count when you 1st import a file. When the data source adds new fields, it breaks the connection. The fix? Delete the hardcoded column count argument in the formula bar!

اليوم الثالث من معسكر Excel والذي يركّز على VBA و Power Query مع د. عبد الله العمير. خطوة قوية نحو الأتمتة، وتقليل التكرار، وبناء حلول أذكى وأكثر كفاءة. بالضبط هذا هو المستوى مما كنت أطمح للوصول إليه. ⚡️ #Excel #VBA #PowerQuery #Au


🚀 Accountants, unlock Power Query—Excel’s data superpower! Import, clean & transform ANY data source in clicks: ✅ Bank feeds → reconciled ✅ Multi-files → one report ✅ No more VLOOKUP hell Free in Excel + fuels Power BI. Master it now: #PowerQuery opencastlabs.co.ke/power-query-wi…


⚡The new Get Data dialog in Excel gives you a clean, simple starting point for connecting to data. Full updates in our #MicrosoftCloudMonday Bulletin 👉 jump.cumulusglobal.com/48ACP8S #Excel #PowerQuery #DataAnalysis #ManagedCloudServices #SmallBusiness

allenfalcon's tweet image. ⚡The new Get Data dialog in Excel gives you a clean, simple starting point for connecting to data. 
Full updates in our #MicrosoftCloudMonday Bulletin 👉 jump.cumulusglobal.com/48ACP8S 

#Excel #PowerQuery #DataAnalysis #ManagedCloudServices #SmallBusiness

⚡The new Get Data dialog in Excel gives you a clean, simple starting point for connecting to data. Full updates in our #MicrosoftCloudMonday Bulletin 👉 jump.cumulusglobal.com/4ofjgI5 #Excel #PowerQuery #DataAnalysis #ManagedCloudServices #SmallBusiness

billatcumulus's tweet image. ⚡The new Get Data dialog in Excel gives you a clean, simple starting point for connecting to data. 
Full updates in our #MicrosoftCloudMonday Bulletin 👉 jump.cumulusglobal.com/4ofjgI5 

#Excel #PowerQuery #DataAnalysis #ManagedCloudServices #SmallBusiness

⚡The new Get Data dialog in Excel gives you a clean, simple starting point for connecting to data. Full updates in our #MicrosoftCloudMonday Bulletin 👉 jump.cumulusglobal.com/44nLx82 #Excel #PowerQuery #DataAnalysis #ManagedCloudServices #SmallBusiness

ccaldwell4cg's tweet image. ⚡The new Get Data dialog in Excel gives you a clean, simple starting point for connecting to data. 
Full updates in our #MicrosoftCloudMonday Bulletin 👉 jump.cumulusglobal.com/44nLx82 

#Excel #PowerQuery #DataAnalysis #ManagedCloudServices #SmallBusiness

⚡The new Get Data dialog in Excel gives you a clean, simple starting point for connecting to data. Full updates in our #MicrosoftCloudMonday Bulletin 👉 jump.cumulusglobal.com/48znbdY #Excel #PowerQuery #DataAnalysis #ManagedCloudServices #SmallBusiness

CumulusGlobal's tweet image. ⚡The new Get Data dialog in Excel gives you a clean, simple starting point for connecting to data. 
Full updates in our #MicrosoftCloudMonday Bulletin 👉 jump.cumulusglobal.com/48znbdY 

#Excel #PowerQuery #DataAnalysis #ManagedCloudServices #SmallBusiness

“When we refresh our query, the data gets resorted… but our manually-entered notes don’t follow the correct rows. Is this a bug or a feature?”🐜 @kpuls helped a student in an AKA call build a solution that preserves notes exactly where they belong. #PowerQuery #Excel #DataModel

skillwave_'s tweet image. “When we refresh our query, the data gets resorted… but our manually-entered notes don’t follow the correct rows. Is this a bug or a feature?”🐜
@kpuls helped a student in an AKA call build a solution that preserves notes exactly where they belong.

#PowerQuery #Excel #DataModel

🚀 Accountants, unlock Power Query—Excel’s data superpower! Import, clean & transform ANY data source in clicks: ✅ Bank feeds → reconciled ✅ Multi-files → one report ✅ No more VLOOKUP hell Free in Excel + fuels Power BI. Master it now: #PowerQuery opencastlabs.co.ke/power-query-wi…


Excelで今日 一番びびったんは Power Queryの速さ データ整形が クリックだけで 一瞬で終わる 手作業で 並べ替えてた頃 戻れへんわこれ 【学びポイント】 外部データ読み込み→変換→列削除→結合 定番操作は全部自動化 #Excel #PowerQuery #時短テク

shinc_v5's tweet image. Excelで今日  
一番びびったんは  
Power Queryの速さ 
データ整形が  
クリックだけで  
一瞬で終わる
手作業で  
並べ替えてた頃  
戻れへんわこれ

【学びポイント】  
外部データ読み込み→変換→列削除→結合  
定番操作は全部自動化
#Excel #PowerQuery #時短テク

Expand your knowledge of #DAX, M Code, #PowerQuery data transformation patterns, and more with our eBooks and other digital downloads. 📚 Save 25% on everything in our @skillwave_ catalog, including eBook bundles, with code 2025CYBER: skw-t.com/cw25-ebooks #PowerBI #Excel


Expand your knowledge of #DAX, M Code, #PowerQuery data transformation patterns, and more with our eBooks and other digital downloads. 📚 Save 25% on everything in our catalog, including eBook bundles, with code 2025CYBER – go to: skw-t.com/cw25-ebooks #PowerBI #DataAnalytics


I improved my Week 4 dashboard using the same dataset, focusing on usability, visual appeal, clarity, and effective data storytelling. @TDataImmersed @DabereNnamani @debby7650 @simplyaryam @JudeRaji_ @MSPowerBI #powerquery #Datatransformation #datacleaning

Af_shade's tweet image. I improved my Week 4 dashboard using the same dataset, focusing on usability, visual appeal, clarity, and effective data storytelling. @TDataImmersed @DabereNnamani @debby7650 @simplyaryam @JudeRaji_ @MSPowerBI  #powerquery #Datatransformation #datacleaning
Af_shade's tweet image. I improved my Week 4 dashboard using the same dataset, focusing on usability, visual appeal, clarity, and effective data storytelling. @TDataImmersed @DabereNnamani @debby7650 @simplyaryam @JudeRaji_ @MSPowerBI  #powerquery #Datatransformation #datacleaning
Af_shade's tweet image. I improved my Week 4 dashboard using the same dataset, focusing on usability, visual appeal, clarity, and effective data storytelling. @TDataImmersed @DabereNnamani @debby7650 @simplyaryam @JudeRaji_ @MSPowerBI  #powerquery #Datatransformation #datacleaning
Af_shade's tweet image. I improved my Week 4 dashboard using the same dataset, focusing on usability, visual appeal, clarity, and effective data storytelling. @TDataImmersed @DabereNnamani @debby7650 @simplyaryam @JudeRaji_ @MSPowerBI  #powerquery #Datatransformation #datacleaning

YT Video Ready !! SEE YOUU TOMORROW 6PM !! #Freedomanalytics #excel #powerquery #excelmagic

ObohX's tweet image. YT Video Ready !! 

SEE  YOUU TOMORROW 6PM !! 

#Freedomanalytics #excel #powerquery #excelmagic

Dynamically Remove null rows in #PowerQuery {M}joy

chandeep2786's tweet image. Dynamically Remove null rows in #PowerQuery
{M}joy

مشروعي الأول في عالم تحليل البيانات فخور بمشاركتي أول مشروع داشبورد تفاعلي أشتغلت عليه باستخدام Excel ضمن دورة تحليل البيانات المقدمة من معسكر SPARK - جامعة الملك خالد كلية الهندسة @AlomairAbdulDS #تحليل_البيانات #Excel #PowerQuery #SPARK_KKU #DataAnalytics

Ok9Fo's tweet image. مشروعي الأول في عالم تحليل البيانات
فخور بمشاركتي أول مشروع داشبورد تفاعلي أشتغلت عليه باستخدام Excel ضمن دورة تحليل البيانات المقدمة من معسكر SPARK - جامعة الملك خالد  كلية الهندسة @AlomairAbdulDS 
#تحليل_البيانات  #Excel
 #PowerQuery #SPARK_KKU #DataAnalytics

Waiting for the results of a merge in #PowerQuery to render in the data view.

ehansalytics's tweet image. Waiting for the results of a merge in #PowerQuery to render in the data view.

名前さえ付けておけば、スピル範囲を追ってくれるわけですか。これは都合がいい。 #PowerQuery #Excel

tanuki_phoenix's tweet image. 名前さえ付けておけば、スピル範囲を追ってくれるわけですか。これは都合がいい。
#PowerQuery #Excel

Try using Table Combine function in #PowerQuery. You'll love it.

chandeep2786's tweet image. Try using Table Combine function in #PowerQuery. You'll love it.

How to write a bad Query. #powerquery {M}joy

chandeep2786's tweet image. How to write a bad Query.
#powerquery {M}joy

2月29日にならなかった。ExcelのEOMONTH関数とは違うんですね。Date.EndOfMonthで解決。#PowerQuery

shusoshin's tweet image. 2月29日にならなかった。ExcelのEOMONTH関数とは違うんですね。Date.EndOfMonthで解決。#PowerQuery

Transform Multiple Columns at once in #PowerQuery #Mjoy

chandeep2786's tweet image. Transform Multiple Columns at once in #PowerQuery
#Mjoy

Have you tried the Using Locale.. option in #PowerQuery?

chandeep2786's tweet image. Have you tried the Using Locale.. option in #PowerQuery?

Getting a Total Row in #PowerQuery is not that hard.

chandeep2786's tweet image. Getting a Total Row in #PowerQuery is not that hard.

Have you been creating Query Groups in #PowerQuery to keep things neat and tidy?

chandeep2786's tweet image. Have you been creating Query Groups in #PowerQuery to keep things neat and tidy?

The DRY Trick. Don't Repeat Yourself even in #PowerQuery #Mjoy

chandeep2786's tweet image. The DRY Trick.
Don't Repeat Yourself even in #PowerQuery
#Mjoy

Hey Fam👋🏻 As a student of @VephlaUni I decided to analyze the What's app Group Chat Engagements of My fellow compatriots 😂 in cohort 8B and this is what I came up with using #Excel #Powerquery #Pivotcharts Beautiful isn't it?? Tell me what you think in the comments section.

The_OnlyLulu's tweet image. Hey Fam👋🏻
As a student of @VephlaUni I decided to analyze the What's app Group Chat Engagements of My fellow compatriots 😂 in cohort 8B and this is what I came up with using #Excel #Powerquery #Pivotcharts Beautiful isn't it??

Tell me what you think in the comments section.
The_OnlyLulu's tweet image. Hey Fam👋🏻
As a student of @VephlaUni I decided to analyze the What's app Group Chat Engagements of My fellow compatriots 😂 in cohort 8B and this is what I came up with using #Excel #Powerquery #Pivotcharts Beautiful isn't it??

Tell me what you think in the comments section.

Loading...

Something went wrong.


Something went wrong.


United States Trends