Calculate the number of days the quantity remained constant from a selected date

[BrianJ]

@satichun,

You may find the following post helpful in solving this. It’s not the exact same case, but very comparable - calculating the number of simultaneous periods in which a number stayed the same sign (as opposed to the exact same value):

Count Consecutive Months that a measure was positive or negative

@nickjordan32, This is a really interesting problem that I’ve been thinking about since you posted it initially, and think I finally cracked it. Had to throw a lot of DAX at it - here are the highlights: Used a series of table functions to create a physical table (pTable) summarizing the relevant fields and measures, where Total Over Under was not blank (but could be zero): pTable = VAR vTable= FILTER( ADDCOLUMNS( SUMMARIZE( Dates, Dates[MonthInCalenda…

• Brian