cancel
Showing results for
Did you mean:
Helper III

## Same Store Sales Growth in Calculation Groups?

Hi all, working in Tabular Editor, I have created some calculation groups that measure YTD/MTD Year over Year growth %, but I would like to only calculate this for locations that had sales in the prior period/year. We've added many new locations in the past year and the growth numbers are obviously inflated because we've added 40 locations in the past 6 months.

Here's what I am using today for my QTD calculation measure.

Placeholder =
VAR CYQTD =
CALCULATE (
SELECTEDMEASURE (),
CALCULATETABLE ( DATESQTD ( 'Calendar'[Date] ), 'Calendar'[IsPast] = TRUE () )
)
VAR PYQTD =
CALCULATE (
SELECTEDMEASURE (),
CALCULATETABLE (
DATEADD ( DATESQTD ( 'Calendar'[Date] )-1YEAR ),
'Calendar'[IsPast] = TRUE ()
)
)
VAR YOYQTD = ( CYQTD - PYQTD )
RETURN
DIVIDE ( YOYQTDPYQTD )

3 REPLIES 3
Super User

@sublog , Assuming you have location[location] or table[location]

Change in your formula at the end

VAR YOYQTD = Sumx(values(Location[Location]), if(not(isblank(PYQTD)), ( CYQTD - PYQTD ), blank()))
RETURN
DIVIDE ( YOYQTD, PYQTD )

Helper III

Okay, I replaced the VAR YOYQTD = ( CYQTD - PYQTD ) section with what you gave me above, but the numbers are not correct? I assume you meant location as the table that contains my locations?

Helper III

Thank you, I will check on this and report back!

Announcements

#### Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors