Count Number of day

[Miniso]

Hello,

I would like to write a Dax formula, counting number of Days based on Product ID. I do not have the start and end date in two diff columns.

Thanks Much Appreciated.

[Miniso]

Thanks!

[wdx223_Daniel · Accepted solution]

CalculatedColumn=VAR _prev=MAXX(FILTER(Table,Table[Product]=EARLIER(Table[Product])&&Table[Date]<EARLIER(Table[Date])),Table[Date] RETURN IF(_prev,Table[Date]-_prev)

Measure=VAR _Curr=MAX(Table[Date]) VAR _Prev=CALCULATE(MAX(Table[Date]),Table[Date]<_Curr) RETURN IF(_Prev,_Curr-_Prev)