Forum Discussion
calen
Helper I
Helper IDate Difference by Items First Ship Date
Good Morning Everyone! I am trying to create a BI report to tracks the success of new projects. Sales gives me their projected volumes for years 1, 2, and 3. I need a measure that looks at the fi...
I'm assuming you want this as a calculated column in your table. That would be something like this.
Days = VAR _ThisDate = 'Item Ledger Entries'[Posting Date] VAR _ProjStart = CALCULATE ( MIN ( 'Item Ledger Entries'[Posting Date] ), ALLEXCEPT ( 'Item Ledger Entries', 'Item Ledger Entries'[Project] ) ) RETURN DATEDIFF ( _ProjStart, _ThisDate, DAY )
jdbuchanan71
Super User
Super UserI'm assuming you want this as a calculated column in your table. That would be something like this.
Days =
VAR _ThisDate = 'Item Ledger Entries'[Posting Date]
VAR _ProjStart = CALCULATE ( MIN ( 'Item Ledger Entries'[Posting Date] ), ALLEXCEPT ( 'Item Ledger Entries', 'Item Ledger Entries'[Project] ) )
RETURN
DATEDIFF ( _ProjStart, _ThisDate, DAY )
calenHelper I
Helper IThis worked beautifuly! Thank you so much!