Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Prior period DAX calculation using automatic time intelligence in Power BI
Prior Month Sales = CALCULATE ( SUM( Sales[Revenue] ), PREVIOUSMONTH( Sales[Date].[Date] ) )
// Quick measure uses DATEADD function instead
Prior Month Sales = CALCULATE ( SUM( Sales[Revenue] ), DATEADD( Sales[Date].[Date], -1, MONTH ) )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment