computaz

194 bookmarks
Custom sorting
Sharing a folder on SharePoint with 'Anyone' greyed out...
Sharing a folder on SharePoint with 'Anyone' greyed out...
Hi,As pictured, the option to share with 'anyone' is greyed out - it says on the Microsoft support site: Note: Anyone option may not be available in your organization depending on the settings your
·answers.microsoft.com·
Sharing a folder on SharePoint with 'Anyone' greyed out...
How To Detect Anomalies And Outliers In Your Data - Microsoft Power BI Community
How To Detect Anomalies And Outliers In Your Data - Microsoft Power BI Community
In this post, I want to dive into anomalies and outliers in your data and how you can analyze and showcase them effectively inside of Power BI.   What I will do is give you a quick explanation of outliers and anomalies. Then leave the rest of the information to the embedded videos to showcase the te...
·community.powerbi.com·
How To Detect Anomalies And Outliers In Your Data - Microsoft Power BI Community
Pricing
Pricing
Brilliant tutorials
·iorad.com·
Pricing
PyQuant News 🐍 on X: "Python is the new Excel. So don't be the only one stuck with 1,048,576 rows. 6 links to help you quickly get started with Python now: https://t.co/RbTjVphS79" / X
PyQuant News 🐍 on X: "Python is the new Excel. So don't be the only one stuck with 1,048,576 rows. 6 links to help you quickly get started with Python now: https://t.co/RbTjVphS79" / X
Python is the new Excel.So don't be the only one stuck with 1,048,576 rows.6 links to help you quickly get started with Python now: pic.twitter.com/RbTjVphS79— PyQuant News 🐍 (@pyquantnews) February 6, 2024
·twitter.com·
PyQuant News 🐍 on X: "Python is the new Excel. So don't be the only one stuck with 1,048,576 rows. 6 links to help you quickly get started with Python now: https://t.co/RbTjVphS79" / X
(6) Post | LinkedIn
(6) Post | LinkedIn
Have you ever needed to compare two tables in Power Query?   Determining a row difference between two tables is most often done like this. In the Power Query… | 11 comments on LinkedIn
·linkedin.com·
(6) Post | LinkedIn
Creating a Crossjoin (All Combinations) in Power Query
Creating a Crossjoin (All Combinations) in Power Query
The article shows how to perform crossjoins in Power Query. Learn how to return all possible combinations between columns in a fast and easy way.
·gorilla.bi·
Creating a Crossjoin (All Combinations) in Power Query
Change Column Type By Position in Power Query - BI Gorilla
Change Column Type By Position in Power Query - BI Gorilla
You can easily change a column type by it's relative position. This requires some basic editing of the M-Code and using the Table.ColumnNames formula.
·gorilla.bi·
Change Column Type By Position in Power Query - BI Gorilla
Weighted Average Calculation in Power BI
Weighted Average Calculation in Power BI
Note: Since the weights (percentages) will always aggregate to 1, I am intentionally not dividing the numerator by sum of weights, just to make the DAX smoot...
·youtube.com·
Weighted Average Calculation in Power BI
Weighted Average DAX
Weighted Average DAX
Hello,   I am trying to use a measure to find the weighted average based on the values in another column per product. My data looks like this:   Product   Date   Value   WeightValue A 1/1/2021 10 1 A 1/2/2021 20 2 A 1/3/2021 30 3 B 1/1/2021 40 4 B 1/2/2021 50 5 B 1/3/2021 60 6 C 1/1/2021 70 7 C 1/2...
·community.fabric.microsoft.com·
Weighted Average DAX
Mixing Table Functions: SUMMARIZE() & FILTER() in Power BI
Mixing Table Functions: SUMMARIZE() & FILTER() in Power BI
Expert guide to mixing table functions: SUMMARIZE() and FILTER() in Power BI. Learn to create summary tables and filter data step-by-step.
·powerbitraining.com.au·
Mixing Table Functions: SUMMARIZE() & FILTER() in Power BI
Working with AverageX and Summarize to create averages in DAX
Working with AverageX and Summarize to create averages in DAX
In this video Mitchell takes a look at some of the challenges that exist when working with averages and then how you can use a combination of DAX functions t...
·youtube.com·
Working with AverageX and Summarize to create averages in DAX
FGW
FGW
·192.168.1.254·
FGW
Rolling 12 Months Average in DAX - SQLBI
Rolling 12 Months Average in DAX - SQLBI
Rolling averages over time (a.k.a. moving averages or running averages) are useful to smoothen chart lines and to make trends more evident. This article sho
·sqlbi.com·
Rolling 12 Months Average in DAX - SQLBI
Reading Zip files in PowerQuery / M
Reading Zip files in PowerQuery / M
Being a fan of PowerBI, I recently looked for a way to read zip files directly into the Data Model, and found this blog which showed a usab...
·sql10.blogspot.com·
Reading Zip files in PowerQuery / M
Disable focus mode in Power BI in 3 easy steps
Disable focus mode in Power BI in 3 easy steps
If you want to disable Focus mode in Power BI, first go to the Format pane in Visualizations, and then select Visual header.
·windowsreport.com·
Disable focus mode in Power BI in 3 easy steps
Find Files By Date Modified in Windows
Find Files By Date Modified in Windows
Tips on how to find a file by when it was modified in Microsoft Windows Vista, Windows 7, Windows 8, and Windows 10.
datemodified:
·computerhope.com·
Find Files By Date Modified in Windows
The M language - Power Query How
The M language - Power Query How
The Power Query M language, commonly referred to as "M," is a powerful data transformation and data preparation language designed specifically for Microsoft's
·powerquery.how·
The M language - Power Query How
PUSH the limits of Power BI native VISUALS and CAPTIVATE your audience | TIMELINE chart Step-by-Step
PUSH the limits of Power BI native VISUALS and CAPTIVATE your audience | TIMELINE chart Step-by-Step
In this video I present the way to make a timeline chart using only native visuals in Power BI. Learn the few tricks that make this visual possible and keep them for the future out-of-the -box ideas! Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :) Download link: https://my.datatraining.io/course?courseid=howtopowerbifiles -------------------------------- 📊 TRAININGS 📊 --------------------------------- New! Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powerbidesigntransformation Learning Path https://my.datatraining.io/subscriptions?id=power-bi-zero-to-hero For Custom Trainings and Consulting email directly support@datatraining.io --------------------------------- ⏱️ TIMESTAMPS ⏱️ --------------------------------- 00:00 Intro 01:00 Data Model and Dataset 01:40 Creating Markers Building the Timeline with a Line chart (Step 1) 05:59 Creating Drop Down Lines with Error bars (Step 2) 07:53 Combine it with the Area Chart (Step 3) 10:28 Area Chart Trick you Need to Know 11:49 Add additional information 15:53 End --------------------------------- 😍 JOIN 😍 ---------------------------------- Subscribe: https://bit.ly/31MnQGO​ Website: https://www.datatraining.io Facebook: https://www.facebook.com/groups/howtopowerbi LinkedIn: https://www.linkedin.com/company/datatraining-io Insta: https://www.instagram.com/howtopowerbi/ Twitter: https://twitter.com/HowToPowerBI --------------------------------- 👇 CHECK THIS OUT! 👇 --------------------------------- 💻 My gear https://a.co/69HEjRu 📚 Power BI books MUST READ! https://a.co/5q5k6Dv 💡 General books I recommend https://a.co/05I4W2L 🎶 Music for my videos https://www.epidemicsound.com/referral/8pjcbj 🚀 For growing on YouTube: https://www.tubebuddy.com/bas 🏄 Stuff I use daily https://a.co/4V5CUJN * 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​ #DAX
·youtube.com·
PUSH the limits of Power BI native VISUALS and CAPTIVATE your audience | TIMELINE chart Step-by-Step