Grouping & Segmenting Your Data With DAX Measure Logic - Advanced DAX
An advanced DAX technique for Power BI which enables you to group information via a supporting table that contains some inner and outer limits to each segment. More advanced DAX technique but very versatile and can be used in many situations.
***** Video Details *****
0:55 - introduction
3:31 - creating a supporting table
8:18 - checking the logic
9:19 - creating a matrix
9:58 - creating the visualizations
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
Advanced Segmentation Example Using DAX in Power BI - https://blog.enterprisedna.co/2017/10/31/advanced-segmentation-example-using-dax-in-power-bi/
Group Customers Dynamically By Their Ranking w/DAX In Power BI - https://blog.enterprisedna.co/2017/11/29/group-customers-dynamically-by-their-ranking-wdax-in-power-bi/
Learn Which Customer Groups Experienced The Greatest Growth – Power BI & DAX - https://blog.enterprisedna.co/2018/07/18/know-which-customer-groups-experienced-the-greatest-growth-power-bi-dax/
***** Related Course Modules *****
Advanced DAX Combinations - http://portal.enterprisedna.co/p/advanced-dax-combinations
Unique Analytical Scenarios - http://portal.enterprisedna.co/p/unique-analytical-scenarios
Learning Summit Series - http://portal.enterprisedna.co/p/learning-summit-series
***** Related Support Forum Posts *****
Data grouping and missing month - https://forum.enterprisedna.co/t/data-grouping-and-missing-month/2238
General Ledger Grouping - https://forum.enterprisedna.co/t/general-ledger-grouping/78
Dynamic Grouping - Last Month Value - https://forum.enterprisedna.co/t/dynamic-grouping-last-month-value/1275
For more grouping data support queries to review see here -
https://forum.enterprisedna.co/search?q=grouping%20data
Видео Grouping & Segmenting Your Data With DAX Measure Logic - Advanced DAX канала Enterprise DNA
***** Video Details *****
0:55 - introduction
3:31 - creating a supporting table
8:18 - checking the logic
9:19 - creating a matrix
9:58 - creating the visualizations
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
Advanced Segmentation Example Using DAX in Power BI - https://blog.enterprisedna.co/2017/10/31/advanced-segmentation-example-using-dax-in-power-bi/
Group Customers Dynamically By Their Ranking w/DAX In Power BI - https://blog.enterprisedna.co/2017/11/29/group-customers-dynamically-by-their-ranking-wdax-in-power-bi/
Learn Which Customer Groups Experienced The Greatest Growth – Power BI & DAX - https://blog.enterprisedna.co/2018/07/18/know-which-customer-groups-experienced-the-greatest-growth-power-bi-dax/
***** Related Course Modules *****
Advanced DAX Combinations - http://portal.enterprisedna.co/p/advanced-dax-combinations
Unique Analytical Scenarios - http://portal.enterprisedna.co/p/unique-analytical-scenarios
Learning Summit Series - http://portal.enterprisedna.co/p/learning-summit-series
***** Related Support Forum Posts *****
Data grouping and missing month - https://forum.enterprisedna.co/t/data-grouping-and-missing-month/2238
General Ledger Grouping - https://forum.enterprisedna.co/t/general-ledger-grouping/78
Dynamic Grouping - Last Month Value - https://forum.enterprisedna.co/t/dynamic-grouping-last-month-value/1275
For more grouping data support queries to review see here -
https://forum.enterprisedna.co/search?q=grouping%20data
Видео Grouping & Segmenting Your Data With DAX Measure Logic - Advanced DAX канала Enterprise DNA
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Easy Grouping Or Binning with Power BI - No Code!Build a Slicer Panel in Power BI and take it to the next levelCombining Dynamic Grouping With Additional Ranking Logic w/DAX for Power BIUnderstanding The CALCULATE Function - (1.12) Ultimate Beginners Guide to DAX 2019How To Segment Your Data Based On Any Measure In Power BI Using DAXPower BI Group By - Using Query Editor, DAX, and Some Magic!✨Handling MULTIPLE fact tables in Power BIREDUCE the # of measures with Calculation Groups In Power BIDAX Fridays! #77: GROUPBY, CURRENTGROUPSUM vs SUMX What's The Real Difference Between These DAX MeasuresAdvanced Scenario Analysis Techniques For Power BI w/DAXAdvanced DAX [Full Course]Cumulative Totals Deep Dive - Power BI & DAX Formula ReviewThe Great New Hidden DAX Function Pt. 2 – Dynamic AnalysesCalculate Difference This Year vs Last Year in Power BI with DAXCustomers Grouped by the Count of their Orders – Dynamic Segmentation in Power BI Using DAX Measures3 Complex DAX ExamplesShow MTD, QTD & YTD Calculations To Current Date in Power BI w/DAXHow To Create Virtual Groups & New Dimensions Fast in Power BI