Discussion

Mohamad Mahmood

Programming (Mobile, Web, Database and Machine Learning). Studying at the Center For Artificial Intelligence Technology (CAIT), FTSM, UKM MY

Sep 17, 2024

Power BI DAX: CALCULATE, DATESBETWEEN, STARTOFYEAR, PREVIOUSYEAR, LASTDATE, SAMEPERIODLASTYEAR

Sales PYTD = VAR StartYear = STARTOFYEAR ( PREVIOUSYEAR ( 'Calendar'[Date] ) ) VAR EndDate = LASTDATE ( SAMEPERIODLASTYEAR ( 'Calendar'[Date] ) ) RETURN CALCULATE ( [Sales], DATESBETWEEN ( 'Calendar'[Date], StartYear, EndDate ) ) Using t...

hashnotes.hashnode.dev2 min read

#powerbi #dataanalysisexpression-dax

Responses

No responses yet.

Search Hashnode

Power BI DAX: CALCULATE, DATESBETWEEN, STARTOFYEAR, PREVIOUSYEAR, LASTDATE, SAMEPERIODLASTYEAR

Responses

Recent in Forum