topic Count Number of day in DAX Commands and Tips

Count Number of day

Miniso — Tue, 28 Feb 2023 21:09:49 GMT

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.

Re: Count Number of day

wdx223_Daniel — Wed, 01 Mar 2023 00:16:03 GMT

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)

Re: Count Number of day

Miniso — Sat, 04 Mar 2023 04:28:08 GMT

Thanks!