Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Rebasing value to 0 when filtered on date slicer

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 this now.

 

It looks like above image now. I am attaching the desired look below (adjusted, slicer doesn't interact with table below)

 

Capture1.JPG

 

Please suggest. 

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.