DAX: Forecasting Logic Tutorial // Power BI

Подписаться 2,3 тыс.

Просмотров 7 тыс.

50% 1

Join Collectiv expert Grant as he explains how to create a Forecast using DAX and Power BI. You'll be able to better predict trends, set goals, and stay on target with this tutorial.
------------------------------------------------------------------ Let’s Connect! -----------------------------------------------------------------
▸ LinkedIn: / gocollectiv
▸ Website: gocollectiv.com/
▸ Twitter: / gocollectiv
We are Microsoft data platform and Power BI experts who empower C-Suite executives by radically improving data analytics, planning, and AI processes across the enterprise. With passion and experience, Collectiv delivers world-class measurable outcomes via strategy, consulting, advising, and programs. Empower your enterprise with Collectiv.
#PBITutorial #Collectiv #DAX #microsoftpartner #forcasting #dashboardtutorial #powerbi #powerbitutorial

Наука

Опубликовано:

28 апр 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 10

@ChrisOrtegaCEO 3 года назад

Great job!

@audreywright7409 3 года назад

Great video!

@enricomendiola9952 11 месяцев назад

Great video 😊. How to create a measure starrting current date up to December 2024? Instead of of using Sameperiodlastyear

@fw4693 8 месяцев назад

Please how do u consider saisonality ?

@mjagusiak542 Год назад

Curious- for your forecast measure, all you did was pull the data for the previous year and used that as a forecast. Wouldn’t this be a YOY comparison forecast rather than a seasonality forecast?

@gocollectiv Год назад

Hey! We did not have actual forecast data and did not use machine learning to come up with any data. You are right, it would be more of a YOY comparison forecast instead of a seasonality forecast.

@rinsha3397 Год назад

I found Sales LY, But when I try to find forcast : CALCULATE ([Sales LY], FILTER (Dates, Dates[year] = "2022")) I get a column in table for forcast, but no values are showing

@gocollectiv Год назад

Hey! The column is showing up as blank because you are trying to calculate last year's sales, which are already filtered to last year, for next year. You will need to change the reference in your measure from [Sales LY] to [Total Sales]. Hope that helps!

@dardenmueller2147 2 года назад

How did you create the year field under Calendar?

@rauljimenez5485 Год назад

Inside Power Query, you add a column as YEAR ( 'Calendar' [Date]). That is assuming that your dates table is called 'Calendar' and the column is "Date"