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/ay1b216vt4erc1o/AT%20Small%20ABC%20Analysis.pbix?dl=0
Last Video:
Abstract Thesis 138: Learn Power BI: Window as Rank- why and Why not: https://youtu.be/Pu8y8bd5mb8

Official Link December 2022- https://powerbi.microsoft.com/en-us/blog/power-bi-december-2022-feature-summary #post-21693-_Toc121395731
Window: https://learn.microsoft.com/en-us/dax/window-function-dax

Last Video:
Learn in Power BI using DAX, how to do Active Employee Tenure Bucketing, get Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU


Watch full series
Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L


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: https://youtu.be/WLg85yiMgHI


The Blog Link: https://amitchandak.medium.com/power-query-across-table-calculated-column-718809a97fd
The file Link: https://community.powerbi.com/t5/Quick-Measures-Gallery/Power-Query-Across-Table-calculated-column/td-p/2926509

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529

Customer Retention Part 2: Period over Period Retention https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458

Customer Retention Part 5: LTD Vs Period Retention
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retention-is-only/ba-p/2114497


Last Video: Abstract Thesis 87: Power BI Tooltip Page: How to pass selective values to the tooltip page: https://www.youtube.com/watch?v=lEq7YtkxeLU

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-Stories-Gallery/Blog-Analysis/m-p/1265567#M4403
Like, Share, comment, and Give suggestions for improvement, and the next post/video.

Important Links every power bi enthusiastic should bookmark: https://amitchandak.medium.com/important-links-every-powerbi-enthusiastic-should-bookmark-5682c7a3c912

DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
https://www.youtube.com/watch?v=IsfCMzjKTQ0&t=145s

Also, check
Cheat Sheet — Power BI Time Intelligence Formulas Using Today - https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27304

Cheat Sheet — Power BI Calendar that starts with any date of the month — Just two variables apart - https://medium.com/chandakamit/cheat-sheet-calendar-that-starts-with-any-date-of-the-month-just-two-variables-apart-9fb9a0f65b92

-~-~~-~~~-~~-~-
Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI"
https://www.youtube.com/watch?v=cN8AO3_vmlY
-~-~~-~~~-~~-~-