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
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
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