Скачать или смотреть Dax7 - Time intelligence - Previous - Next

Data Analysis Expressions (DAX) includes time-intelligence functions that enable you to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods.

PREVIOUSDAY: Returns a table that contains a column of all dates representing the day that is previous to the first date in the dates column, in the current context.
PREVIOUSMONTH: Returns a table that contains a column of all dates from the previous month, based on the first date in the dates column, in the current context.
PREVIOUSQUARTER: Returns a table that contains a column of all dates from the previous quarter, based on the first date in the dates column, in the current context.
PREVIOUSYEAR: Returns a table that contains a column of all dates from the previous year, given the last date in the dates column, in the current context.

NEXTDAY: Returns a table that contains a column of all dates from the next day, based on the first date specified in the dates column in the current context.
NEXTMONTH: Returns a table that contains a column of all dates from the next month, based on the first date in the dates column in the current context.
NEXTQUARTER: Returns a table that contains a column of all dates in the next quarter, based on the first date specified in the dates column, in the current context.
NEXTYEAR: Returns a table that contains a column of all dates in the next year, based on the first date in the dates column, in the current context.

We can use this function to calculate previous day, previous month, previous quarter, previous year figures as well as figures for all such periods in future.

You can get the .pbix file from here.
https://tinyurl.com/yyk8xk7x

Enjoy Dax!