Skip to content

Instantly share code, notes, and snippets.

@matt40k

matt40k/YTD Reseller Sales Amount.mdx

Created January 27, 2016 20:23
Show Gist options
  • Save matt40k/886721a77a96dcefd1a5 to your computer and use it in GitHub Desktop.
Save matt40k/886721a77a96dcefd1a5 to your computer and use it in GitHub Desktop.
Download ZIP
Get YTD for Reseller Sales Amount regardless of the date hierarchy used (either Fiscal or Calendar)
Raw
YTD Reseller Sales Amount.mdx

Aggregate( PeriodsToDate ( [Date].[Fiscal].[Fiscal Year] ,[Date].[Fiscal].CurrentMember )

  • PeriodsToDate ( [Date].[Calendar].[Calendar Year] ,[Date].[Calendar].CurrentMember ) , ( [Measures].[Reseller Sales Amount] ) )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment