Analyse Procurement Purchasing Decisions in Power BI using DAX

Here we quickly and easily dive into purchasing data that you may find in a procurement function within an organisation.
In no time at all we are able to extract some decent insight and navigate around the data by layering context by clicking into chart elements
****Video Details****
0:16 - Introduction
1:01 - The Data Set And Data Model
3:19 - Optimising Procurement Using An Iterating Function
6:25 - Extracting Insights From Procurement Analysis
8:23 - More Visualization Effects
9:57 - Conclusion
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterpri...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterpri...
FREE - 60 Page DAX Reference Guide Download - enterprisedna....
FREE - Power BI Resources - enterprisedna.c...
Enterprise DNA Membership - enterprisedna....
Enterprise DNA Online - portal.enterpri...
Enterprise DNA Events - enterprisedna....
**** Related Links ****
Working With Iterating Functions In DAX
blog.enterpris...
Iterating Functions In DAX Language - A Detailed Example
blog.enterpris...
Using Iterating Functions SUMX And AVERAGEX In Power BI
blog.enterpris...
**** Related Course Modules ****
Business Analytics Series
portal.enterpri...
Mastering DAX Calculations
portal.enterpri...
Unique Analytical Scenarios
portal.enterpri...
**** Related Support Forums ****
Used RELATED In A Measure To Get Text Data From Another Table
forum.enterpri...
Issue With Totaling
forum.enterpri...
Related Function And Relationships
forum.enterpri...
For more SUMX RELATED queries to review see here…..
forum.enterpri...

[@EnterpriseDNA]

***** Related Links ***** Working With Iterating Functions In DAX blog.enterprisedna.co/working-with-iterating-functions-in-dax/ Iterating Functions In DAX Language - A Detailed Example blog.enterprisedna.co/advanced-logic-within-dax-iterating-functions-detailed-example/ Using Iterating Functions SUMX And AVERAGEX In Power BI blog.enterprisedna.co/using-iterating-functions-sumx-and-averagex-in-power-bi/ ***** Related Course Modules ***** Business Analytics Series portal.enterprisedna.co/p/business-analytics-series Mastering DAX Calculations portal.enterprisedna.co/p/mastering-dax-calculations Unique Analytical Scenarios portal.enterprisedna.co/p/unique-analytical-scenarios ***** Related Support Forums ***** Used RELATED In A Measure To Get Text Data From Another Table forum.enterprisedna.co/t/used-related-in-a-measure-to-get-text-data-from-another-table/2996 Issue With Totaling forum.enterprisedna.co/t/issue-with-totaling/144 Related Function And Relationships forum.enterprisedna.co/t/related-function-and-relationships/2383 For more SUMX RELATED queries to review see here….. forum.enterprisedna.co/search?q=sumx%20related

[@OmolaraFash]

Thank you for this video, please where can I get this file?

[@NirRobinson]

Love your work!!! Many thanks. Nir.

[@adityakalra7383]

Hi! Sam McKay, Your videos on power bi are most relevant and give insight into business solutions. I would also love to see a video on Big Data management -20GB with an incremental refresh- Direct Query, as this will solve complex data issues Hope to look forward to your video. Thanks! Aditya Kalra

[@tusharkale1742]

Can I have this power bi file for practise ??

[@EnterpriseDNA]

Hi Tushar kale, thanks for posting your comment in the video. All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks! portal.enterprisedna.co/