DATESMTD: Returns a set of dates in the month up to the last date visible in the filter context.
[ Ссылка ]
DATESQTD: Returns a set of dates in the quarter up to the last date visible in the filter context.
[ Ссылка ]
DATESYTD: Returns a set of dates in the year up to the last date visible in the filter context.
[ Ссылка ]
TOTALMTD: Evaluates the specified expression over the interval which begins on the first of the month and ends with the last date in the specified date column after applying specified filters.
[ Ссылка ]
TOTALQTD: Evaluates the specified expression over the interval which begins on the first day of the quarter and ends with the last date in the specified date column after applying specified filters.
[ Ссылка ]
TOTALYTD: Evaluates the specified expression over the interval which begins on the first day of the year and ends with the last date in the specified date column after applying specified filters.
[ Ссылка ]
This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.
How to learn DAX: [ Ссылка ]
The definitive guide to DAX: [ Ссылка ]
Code, run, and share DAX with DAX.do: [ Ссылка ]
#dax #powerbi #ssas #tabular #analysisservices #powerpivot
