Power BI: scenario analysis (part 1)
In this video, we'll learn how to do a scenario analysis using DAX. In the first part of the tutorial, we analyze how a price change affects total sales.
To do this, we'll build a supporting table with different prices, connect the table to a new sales measure and then shock the prices to see the price impact.
To learn more about how Power BI based solutions may benefit operational efficiency in your company's finance and controlling departments, please check out: https://centida.com/blog/
#PowerBI #DAX
#scenarioanalysis
Видео Power BI: scenario analysis (part 1) канала Siberian_valenok
To do this, we'll build a supporting table with different prices, connect the table to a new sales measure and then shock the prices to see the price impact.
To learn more about how Power BI based solutions may benefit operational efficiency in your company's finance and controlling departments, please check out: https://centida.com/blog/
#PowerBI #DAX
#scenarioanalysis
Видео Power BI: scenario analysis (part 1) канала Siberian_valenok
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Две таблицы фактов в модели Power BI](https://i.ytimg.com/vi/M3ZQNcNPIQA/default.jpg)
![Годовой план продаж в Power BI](https://i.ytimg.com/vi/qeF1ncFTLQU/default.jpg)
![Power BI: DAX Calculate Intermediate (part 1)](https://i.ytimg.com/vi/3zjXoL9zNgQ/default.jpg)
![Сводные таблицы Excel: 7 приёмов для среднего уровня](https://i.ytimg.com/vi/msW_jU5ppxY/default.jpg)
![Сценарный анализ в Power BI](https://i.ytimg.com/vi/9FZiN_PekIs/default.jpg)
![Power BI: scenario analysis (part 2)](https://i.ytimg.com/vi/wL6uKI0lzPY/default.jpg)
![Power BI: using SumIF and CountIF](https://i.ytimg.com/vi/W-aCvuZh5d0/default.jpg)
![Power BI: using SWITCH function](https://i.ytimg.com/vi/8yi_0Yi71Es/default.jpg)
![Power BI: using IF statement](https://i.ytimg.com/vi/TZl6A_8B-aU/default.jpg)
![Power BI: using variables (part 2)](https://i.ytimg.com/vi/gWQtBbRJi3c/default.jpg)
![Power BI: Introduction to Variables](https://i.ytimg.com/vi/oGQ8Yf4DG9k/default.jpg)
![Power BI: Year-to-Date vs Running Total](https://i.ytimg.com/vi/HWolXtU86iM/default.jpg)
![Power BI: time-intelligence functions (part 2)](https://i.ytimg.com/vi/zu95l3p1NhI/default.jpg)
![Power BI: time-intelligence functions (part 1)](https://i.ytimg.com/vi/1rDf6CGc5aA/default.jpg)
![Power BI: ALL and FILTER inside DAX Calculate function](https://i.ytimg.com/vi/-pPR5SSuwoM/default.jpg)
![Power BI: SUMX iterator function](https://i.ytimg.com/vi/omTC_Lk3shs/default.jpg)
![Power BI: DAX Calculate function](https://i.ytimg.com/vi/9GajfWYjp9s/default.jpg)
![Power BI: basic DAX functions](https://i.ytimg.com/vi/_1rCQyTX6Bc/default.jpg)
![Intro to DAX: difference between Excel and DAX](https://i.ytimg.com/vi/Uo1OTd7cCqk/default.jpg)
![Power BI: calendar Table](https://i.ytimg.com/vi/-rH_yBXcBQk/default.jpg)