Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello everyone,
I am new to DAX measures in Power BI and couldn't find my way around rebasing values. I have a list of public firms and their share price changes for over a year (from 02 Jan 2019 till date). I have a date slicer for the same dates. The first row values i.e. the share price change % for the first day/2nd Jan 2019 is zero. What I am looking for is when I filter on the dates slicer - for example to see the moement between say 15 March and today, the value for 15 March should be zero (rebased to 0 on 15th March)
It looks like this now.
It looks like above image now. I am attaching the desired look below (adjusted, slicer doesn't interact with table below)
Please suggest.
You have to have a proper Calendar in your model. Then
Payment Change DoD% 2 =
var __oneDateVisible = HASONEVALUE( Calendar[Date] )
return
if( __oneDateVisible,
var __previousDay =
CALCULATETABLE(
VALUES( 'Calendar'[Date] ),
PREVIOUSDAY( 'Calendar'[Date] ),
ALLSELECTED( 'Calendar' )
)
var __currDayPrice = [Total Payment]
var __prevDayPrice =
CALCULATE(
[Total Payment],
__previousDay
)
var __delta = __currDayPrice - __prevDayPrice
return
DIVIDE( __delta, __prevDayPrice ) + 0
)
This is a TOP-LEVEL measure and cannot be used in iterators of any kind. Please do not use this in other measures.
Best
D
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 9 | |
| 8 | |
| 6 | |
| 5 | |
| 5 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 18 | |
| 14 | |
| 14 |