#powerquery результаты поиска

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……

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.😎

Did you know these 3 neat #PowerQuery tricks? 😉


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


Power Query M関数のList.Accumulate関数を先に学んでいたことが、Excelワークシート関数のLAMBDA関数を理解する助けになりました。 #Excel #PowerQuery

タイムラインの方々は普通にLAMBDA関数を使っている人が多いですけれど。 たぶん、概念としては相当難しいと思いますよ。パッパッと使えるほうがおかしいと思います。 私は(別言語ですが)年単位で時間がかかっている気がします。



Dynamically Remove null rows in #PowerQuery {M}joy

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

Combine and Expand Tricks in #PowerQuery


How many of these #PowerQuery tricks do you know?


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

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

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…


Excelの標準機能であるPower QueryとPower Pivotをつかって、それぞれ用意した予算と見込と実績をつなぎ合わせて集計してます。 標準機能が属人化するとなると、その原因は分からない側の方の勉強不足ということで😁 #Excel #PowerQuery #PowerPivot

なんか、何でやっても属人化しそう、というか。 普通のシステムで対応できる程度のシンプルさなら、エクセルでやっても属人化しなさそうな気もします。 (予算業務やったことないので、雰囲気で書いてます)



勝手ながら、GUIベースで整理してみました。 (1)データ列を複製 (2)duration型に変換 (3)エラーをnullに置換 (4)nullでフィルター (5)複製した列を削除 という流れです。 let式はAltに。 #Excel #PowerQuery #勝手にエクセルクイズ

YasuDT3's tweet image. 勝手ながら、GUIベースで整理してみました。

(1)データ列を複製
(2)duration型に変換
(3)エラーをnullに置換
(4)nullでフィルター
(5)複製した列を削除

という流れです。

let式はAltに。
#Excel
#PowerQuery
#勝手にエクセルクイズ

同じ列にこんなデータが混在してて… ・数字 ・時間⌚ ・文字列 パワークエリで 文字列だけを 抽出しようと頑張ってるけど むずいw💦 (;´∀`) VBAでやろうかな…

chisa91010081's tweet image. 同じ列にこんなデータが混在してて…
・数字
・時間⌚
・文字列

パワークエリで
文字列だけを
抽出しようと頑張ってるけど
むずいw💦
(;´∀`)

VBAでやろうかな…


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.


Ever noticed that you have to refresh your #PowerQuery twice in order to get the changes to show up in your #Excel #PivotTable? In this episode of Monkey Shorts, I'll show you how to fix this issue. 👏 youtube.com/watch?v=gTttJj… #DataPreparation #DataAnalysis #DataAnalyticsTools

kpuls's tweet card. One click refresh of Power Query based Pivot Tables - Monkey Shorts...

youtube.com

YouTube

One click refresh of Power Query based Pivot Tables - Monkey Shorts...


Imagine you have tiered pricing, where the cost is based on the number of units purchased. #PowerQuery can help you quickly determine the price/unit with this "Approximate Match" recipe. Get the full set at skw-t.com/pqrecipes 🤫Until Dec 5, save 25% with code: 2025CYBER

skillwave_'s tweet image. Imagine you have tiered pricing, where the cost is based on the number of units purchased. #PowerQuery can help you quickly determine the price/unit with this "Approximate Match" recipe.

Get the full set at skw-t.com/pqrecipes
🤫Until Dec 5, save 25% with code: 2025CYBER

Still reporting manually in Excel? 🚫 Level up with Power Query and Pivot Tables to automate and speed up your work! Learn more: shorturl.at/ZgbTB #Excel #PowerQuery #ExcelTips #DataAnalysis #Edoxi

edoxi_official's tweet image. Still reporting manually in Excel? 🚫

Level up with Power Query and Pivot Tables to automate and speed up your work!

Learn more: shorturl.at/ZgbTB

#Excel #PowerQuery #ExcelTips #DataAnalysis #Edoxi

Did you know these 3 neat #PowerQuery tricks? 😉


The new edition of our newsletter has just been sent, so time to check your inbox. 📬 Not subscribed? Sign up at skw-t.com/news for what's new in #Excel & #PowerBI, the latest expert content, & info on courses, events, & specials. You also get our #PowerQuery eBook!🎁

skillwave_'s tweet image. The new edition of our newsletter has just been sent, so time to check your inbox. 📬
Not subscribed? Sign up at skw-t.com/news for what's new in #Excel & #PowerBI, the latest expert content, & info on courses, events, & specials. You also get our #PowerQuery eBook!🎁

Data professionals, it's time to level up! 📈 Stop the repetitive #DataCleaning and start focusing on #DataAnalysis. Learn how to save time and boost your career with #PowerQuery. 💼 Enroll now at @skillwave_ and enter code 2025CYBER to save 25%. Go to skw-t.com/cw25-pqa


Here's what's new this month in #Excel, including a new, more modern "Get Data" (i.e. #PowerQuery) experience that is now being unrolled to Current Channel on Excel for Windows: techcommunity.microsoft.com/blog/excelblog…


I heard people say “Twitter is the place where strangers turn into opportunities.” The more I explore it, the more I believe it. You share your journey… and suddenly someone out there helps you get closer to your dream? #PowerBI #PowerQuery #DataAnalytics #BuildingInPublic


Data professionals, it's time to level up! 📈 Stop the repetitive #DataCleaning and start focusing on #DataAnalysis. Learn how to save time and boost your career with #PowerQuery. 💼 Enroll now and enter code 2025CYBER at checkout to save 25%. Go to skw-t.com/cw25-pqa


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.


🚀 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. #PowerQuery opencastlabs.co.ke/power-query-wi…


#PowerQuery Functions Explained: From Simple Cleanup to Dynamic Transformations from @TigerAnalytics community.fabric.microsoft.com/t5/Power-BI-Co… #PowerBI


Project no.2 ✅ Netflix Dashboard in Power BI Took a messy 2019 dataset → cleaned everything in Power Query (duplicates, multi-value columns, duration mess) Now: 68 years, 30 genres, 3,792 movies peak, Dramas rule 🔥 #PowerBI #DataAnalytics #PowerQuery

I52780Israel's tweet image. Project no.2 ✅ Netflix Dashboard in Power BI Took a messy 2019 dataset → cleaned everything in Power Query (duplicates, multi-value columns, duration mess) Now: 68 years, 30 genres, 3,792 movies peak, Dramas rule 🔥 #PowerBI #DataAnalytics #PowerQuery

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……

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

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

Dynamically Remove null rows in #PowerQuery {M}joy

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

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.

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

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.😎

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?

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

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

Transform Multiple Columns at once in #PowerQuery #Mjoy

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

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

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

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

Ever wondered how to detect column types and positions in Power Query? 🧐 TableSchema is a super handy function to do that! Oh, and by the way, in case you didn’t know, my #PowerQuery book is officially launched! 🎉 Feel free to grab a copy and raise the bar beyond Power Query's…


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