Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.