cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors