Power BI DAX: TOTALYTD
Updated
•1 min readM
Mohamad's interest is in Programming (Mobile, Web, Database and Machine Learning). He is studying at the Center For Artificial Intelligence Technology (CAIT), Universiti Kebangsaan Malaysia (UKM).
Total Sales YTD =
TOTALYTD(
[Total Sales],
'Date'[Date]
)
Calculating the cumulative total sales from the beginning of the year up to the current date.
Explanation:
TOTALYTD: This function calculates the year-to-date total of a measure.
[Total Sales]: This is the measure you want to aggregate.
'Date'[Date]: This specifies the date column from your 'Date' table.
14 views