DAX for Power BI: 12 Month Rolling Average

Описание к видео DAX for Power BI: 12 Month Rolling Average

In this DAX tutorial, we learn how to write the DAX query to calculate 4 week, 6 month, and 12 month rolling averages (aka Moving Average) in order to visualize our sales trends. DAX queries are an important way to build an awesome Power BI report that tells a compelling story.

NOTE: Make sure to use a negative interval such as -28 when using the DATESINPERIOD function. This ensures that you are averaging the past 28 days and not the future.

Enroll in my introductory or advanced Power BI courses:
https://training.bielite.com/

Elite Power BI Consulting:
https://bielite.com/

Data Insights Tools:
https://www.impktful.com/

Комментарии

Информация по комментариям в разработке

Похожие видео