Forum Discussion

Mahadevaraobc's avatar
Mahadevaraobc
Icon for Helper II rankHelper II
6 years ago

Difference between date and run if

Hi i have the following sample table, and i want to achieve the following.Each product can have multiple event nos.  a) Calculate date difference between 1st and last events for same product b) Mar...
Need Help
Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Mahadevaraobc ,

 

Here is the event span, have to do something else, will be back.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

 

Event Span = DATEDIFF(FIRSTDATE(Event[Date]),LASTDATE(Event[Date]),DAY)

 

 

Mahadevaraobc's avatar
Mahadevaraobc
Icon for Helper II rankHelper II
6 years ago

Hi Nathaniel_C,

 

Thanks for replying, this answers part of my question, could you help me with the other question...