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.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |