Dealing With Products That Have Changing Prices - Power BI Analytical Techniques Using DAX
It's quite common to have data where the pricing of products or goods can change over time. Price is not always static.
In Power BI this is a modeling and formula challenge that needs to be overcome to showcases true historically and even forecast results. I run through all the tips and techniques required to get this working in Power BI.
**** Video Details ****
5:00 - calculate average product pricing
5:54 - using TREATAS function
8:00 - using the LOOKUPVALUE function
**** 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 ****
Deep Dive Into The TREATAS Function – Virtual Relationships For Power BI - https://blog.enterprisedna.co/2018/09...
How To Create Virtual Relationships Using TREATAS In Power BI - https://blog.enterprisedna.co/2019/07...
Multiple Currency Logic In Power BI – LOOKUPVALUE Example - https://blog.enterprisedna.co/2017/12...
**** Related Course Modules ****
DAX Formula Deep Dives - http://portal.enterprisedna.co/p/dax-...
Advanced DAX Combinations - http://portal.enterprisedna.co/p/adva...
Scenario Analysis Deep Dive - http://portal.enterprisedna.co/p/scen...
**** Related Support Forum Posts ****
TREATAS – Reconciling The Numbers - https://forum.enterprisedna.co/t/trea...
Scenario Analysis – Monthly Using Nested TREATAS - https://forum.enterprisedna.co/t/scen...
Converting Currency - https://forum.enterprisedna.co/t/conv...
For more TREATAS support queries to review see here…. - https://forum.enterprisedna.co/search...
Смотрите видео Dealing With Products That Have Changing Prices - Power BI Analytical Techniques Using DAX онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Enterprise DNA 10 Июнь 2018. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 17,704 раз и оно понравилось 201 посетителям.
