Forum Discussion

pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
6 years ago

Filtered DateDIFF

Hi. I want to calculate measure which show a date difference between today and last transaction on particular item. But to this calculation I want to take only specified type of transactions (Trans...
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

hi pawelj795 

try a measure

=DATEDIFF(
TODAY();
calculate(MAX(Invent_Trans[Date_Physical]);OR(Invent_Trans[TransType] = 0; Invent_Trans[TransType]9));DAY
)

  

do not hesitate to give a kudo to useful posts and mark solutions as solution