Power BI ABC Analysis using Window function, Dynamic Segmentation

Learn how to ABC analysis power bi DAX Window function using the Order by measure with REL position. Use the independent table to create an ABC slicer and work across dimensions. #powerbi #dax prepare for PL 300 certification, Mastering the leading BI tool, Mastering Power BI #powerbipro #powerquery #dax #learnpowerbi #amitchandakdak

Abstract Thesis 139: Power BI ABC Analysis using Window function, Dynamic Segmentation

--Content
00:00 Introduction
00:30 Power BI Model Overview
02:30 Measure for ABC Analysis
08:00 ABC Analysis using Independent Table

Pbix file- https://www.dropbox.com/s/ay1b216vt4e...
Last Video:
Abstract Thesis 138: Learn Power BI: Window as Rank- why and Why not:    • Learn Power BI: Window as Rank- why a...  

Official Link December 2022- https://powerbi.microsoft.com/en-us/b...
Window: https://learn.microsoft.com/en-us/dax...

Last Video:
Learn in Power BI using DAX, how to do Active Employee Tenure Bucketing, get Hired, Terminated, and Active employees:    • Master HR Analytics in Power BI: Empl...  


Watch full series
Expertise Power BI:    • Expertise Power BI- How to Change Con...  


Last Video:
Power BI How to create two columns (split) and formatted financial Profit and Loss (PnL) Statement, Balance sheet. Traditional income statements, P&L, and Balaesheet have a format with blank rows in between, and total across rows.

Power BI create two columns format Profit and Loss Statement AT 120:    • Power BI Profit & Loss Statement: Cre...  


The Blog Link:   / power-query-across-table-calculated-column  
The file Link: https://community.powerbi.com/t5/Quic...

Customer Retention Part 1:
https://community.powerbi.com/t5/Comm...

Customer Retention Part 2: Period over Period Retention https://community.powerbi.com/t5/Comm...

Customer Retention Part 5: LTD Vs Period Retention
https://community.powerbi.com/t5/Comm...


Last Video: Abstract Thesis 87: Power BI Tooltip Page: How to pass selective values to the tooltip page:    • Abstract Thesis 87: Power BI Tooltip ...  

This link will take you to the power bi dashboard that has links for all my blogs and video -You can get all my posts at
https://community.powerbi.com/t5/Data...
Like, Share, comment, and Give suggestions for improvement, and the next post/video.

Important Links every power bi enthusiastic should bookmark:   / important-links-every-powerbi-enthusiastic...  

DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
   • Learn Power BI 2- DAX Standard, Fisca...  

Also, check
Cheat Sheet — Power BI Time Intelligence Formulas Using Today -   / cheat-sheet-power-bi-time-intelligence-for...  

Cheat Sheet — Power BI Calendar that starts with any date of the month — Just two variables apart -   / cheat-sheet-calendar-that-starts-with-any-...  

~-~~-~~~-~~-~
Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI"
   • Microsoft Power BI Tutorial For Begin...  
~-~~-~~~-~~-~