Using Complex Logic Inside Iterating Functions - Advanced DAX

Published: 07 August 2017
on channel: Enterprise DNA
8,427
129

Iterating functions in the DAX language give you immense analytical power if you know how far you can extend then. Usually you are asked for a table and then an expression, but don't feel restricted in what you can put in here. You can get really complex and I'll show you how in this video.

**** Video Details ****
2:06 - sale price greater than $2000
5:24 - sale price greater than $500
6:06 - visualising the data

**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
FREE - Power BI Resources - https://enterprisedna.co/power-bi-res...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...

**** Related Links ****
Using Iterating Functions SUMX And AVERAGEX In Power BI - https://blog.enterprisedna.co/2019/12...
Advanced Logic Within DAX Iterating Functions – Detailed Example - https://blog.enterprisedna.co/2017/12...
How To Understand Virtual Tables Inside Iterating Functions In Power BI – DAX Concepts - https://blog.enterprisedna.co/2018/10...

**** Related Course Modules ****
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mast...
DAX Formula Deep Dives - http://portal.enterprisedna.co/p/dax-...
Advanced DAX Combinations - http://portal.enterprisedna.co/p/adva...

**** Related Support Forum Posts ****
Combining Aggregating & Iterating Functions To Calculate Median - https://forum.enterprisedna.co/t/comb...
Doubt Understanding Iterators - https://forum.enterprisedna.co/t/doub...
Complex Allocation Rules Involving Table Scan And Using DAX Logic - https://forum.enterprisedna.co/t/comp...
For more iterating function support queries to review see here…. - https://forum.enterprisedna.co/search...


Watch video Using Complex Logic Inside Iterating Functions - Advanced DAX online, duration hours minute second in high quality that is uploaded to the channel Enterprise DNA 07 August 2017. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 8,427 times and liked it 129 visitors.