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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
MEEnergy
Frequent Visitor

How to Calculate and show value for 2 days prior based on Date Filter

I have a report that need to always show the previous 2 days value based on a date selection filter.  For example, if the user filters the report for 2/10/2019, the value should be calculated for 2/8/2019.  
I have been able to get this to work using the today() functions but I need this to look back 2 days prior based on any date selection.  
The below code works
CALCULATE([CI],Dim_Date[Date] = TODAY()-2)


I would need it to calculate this way but it is not working correctly

 

CALCULATE([CI],Dim_Date[Date]-2)

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@MEEnergy ,

Please change your DAX to the following:

Measure = 
VAR  SelectedDate = SELECTEDVALUE(Dim_Date[Date])

RETURN CALCULATE([CL],Yourtable[Date]=SelectedDate-2)



Regards,
Lydia

View solution in original post

3 REPLIES 3
MEEnergy
Frequent Visitor

Exactly what I needed.  Thanks!

Anonymous
Not applicable

 
Anonymous
Not applicable

@MEEnergy ,

Please change your DAX to the following:

Measure = 
VAR  SelectedDate = SELECTEDVALUE(Dim_Date[Date])

RETURN CALCULATE([CL],Yourtable[Date]=SelectedDate-2)



Regards,
Lydia

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors