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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

Select a date and show sum of data until this date

Hello, 

 

I have a complex problem, 

I resolved it using tables in DAX but i want to know if it's possible to use with measure

 

I have a table with dates

 

1/01 1 

2/01 2 

3/01 2

4/01 1

5/01 2

 

And for example, if i select 3/01, i want that it sums until 3/01 but show the rest of the table by this date

 

3/01 1+2+2 = 5

4/01                1

5/01                2

 

I resolved it using the date table with VAR SelectedDate and If Date[Date] < SelectedDate then SelectedDate in the Table view

 

But do you know if it's possible with another method with DAX measure and select a date in the report ?

 

Thank you in advance. 

 

 

1 REPLY 1
Ahmedx
Super User
Super User

you should use a disabled date table

Screenshot_2.pngScreenshot_3.png

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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
Top Kudoed Authors