Moving Total and Moving Average using DATESINPERIOD in Power BI
Hi All,
In this video, we will learn how to calculate Moving Total and Moving Average using DATESINPERIOD function of DAX in Power BI.
The sub-topics covered are:
DATESINPERIOD Theory
Overview of the data model
How DATESINPERIOD overrides the current filter context
Calculating Moving Annual Total using DATESINPERIOD
Overview of DISTINCTCOUNT function
Calculating Moving Annual Average using DATESINPERIOD
Link to blog: https://mlforanalytics.com
Link to facebook page: facebook.com/mlforanalytics
Link to LinkedIn handle: / mlforanalytics
Link to Twitter: / jyotidixit1711
Link to Instagram: / mlforanalytics
Like, comment, share the video and subscribe to our channel.
#DATESINPERIOD #MovingAverage #MovingTotal #PowerBI #DAX