Comparison of weeks

[GabrielRF]

I want to compare the values ​​for the week of January 1st with the week of February 1st, does anyone know of a function that solves this?

[Greg_Deckler · Accepted solution]

@GabrielRF You can find the first week of the month by doing something like this:

Measure = 
  VAR __FWJan = WEEKNUM( DATE( 2024, 1, 1 ) )
  VAR __FWFeb = WEEKNUM( DATE( 2024, 2, 1 ) )
  VAR __Jan = SUMX( FILTER( 'Table', WEEKNUM([Date]) = __FWJan ), [Value] )
  VAR __Feb = SUMX( FILTER( 'Table', WEEKNUM([Date]) = __FWFeb ), [Value] )
  VAR __Result = __Feb - __Jan
RETURN
  __Result