Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I wanted to calculate the accumulated quantity sum from min start date untill the one day before date I selected. Is this DAX correct?
I created a dim_date table calendar and this table is linked to item ledger entries table, one to many relationship,
Can anyone help?
Thanks a bunch!
Hi @Shineccx007
possible alternative as following:
part of measure starting with CALCULATE, part DATESINPERIOD replace with
FILTER (
'dim_date',
'dim_date'[Date] >= Start_day &&
'dim_date'[Date] <= Last_day
)
Proud to be a Super User!
Hi Bih,
Seems this solution not working on my end.
I think power bi showed wrong on my DAX showing the date before I selected. selected value of the date -1 is not working in my measure dax.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
10 | |
6 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |