79226962

Date: 2024-11-26 13:50:18
Score: 1
Natty:
Report link

Here is a workaround for you.

  1. Created a new table

enter image description here

  1. sort the column1 by sort column

enter image description here

  1. create a date2 column in original table enter image description here

  2. Do not create relationship between tables and create a measure

    MEASURE = SWITCH ( TRUE (), SELECTEDVALUE ( 'Table (2)'[Column1] ) IN { "Feb-24", "Mar-24", "Apr-24", "May-24" }, CALCULATE ( SUM ( 'Table'[Sales] ), 'Table'[Date] = SELECTEDVALUE ( 'Table (2)'[Column1] ) ), SELECTEDVALUE ( 'Table (2)'[Column1] ) = "Q1 Sales", CALCULATE ( SUM ( 'Table'[Sales] ), QUARTER ( 'Table'[Date2] ) = 1 ), SELECTEDVALUE ( 'Table (2)'[Column1] ) = "Q2 Sales", CALCULATE ( SUM ( 'Table'[Sales] ), QUARTER ( 'Table'[Date2] ) = 2 ), SELECTEDVALUE ( 'Table (2)'[Column1] ) = "Q1 - Q2 Growth", ( DIVIDE ( CALCULATE ( SUM ( 'Table'[Sales] ), QUARTER ( 'Table'[Date2] ) = 2 ), CALCULATE ( SUM ( 'Table'[Sales] ), QUARTER ( 'Table'[Date2] ) = 1 ) ) - 1 ) * 100 )

enter image description here

enter image description here

Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • No code block (0.5):
Posted by: Ryan