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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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.