Time intelligence functions in dax are used to analyze the data across time. The time can include days, months, quarters, and years, then build and compare calculations over those periods.
Understanding time intelligence functions is very important to developing a wide range of time-based reporting in Power BI.
DATESINPERIOD is a DAX function that returns a table that contains a column of dates that starts with a specified start date and continues for the specified length based on the type of date interval passed to the function. This type of function is extremely useful when you want to show important figures such as…
PARALLELPERIOD is a DAX function that returns a table that contains a series of dates parallel to the dates to the function. This function can be used to calculate numeric columns over a given timeframe and supports monthly, yearly, and quarterly intervals. PARALLELPERIOD Syntax The DAX syntax for PARALLELPERIOD is simple and can be seen…
Mark as date table is the crucial step during the data modeling phase in Power BI, SSAS Tabular, or Power Pivot. You often get into situations where your time intelligence functions do not provide the right results. Fortunately, most of the time, the issue is not in your Power BI DAX measure. Now the question…
