Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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] ), -1, YEAR ),
'Calendar'[IsPast] = TRUE ()
)
)
VAR YOYQTD = ( CYQTD - PYQTD )
RETURN
DIVIDE ( YOYQTD, PYQTD )
@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 )
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?
Thank you, I will check on this and report back!
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |