is it possible to reference a measure to calculate DATEDIFF?

[Anonymous]

Hi all,

i am using the following measure to caluclate the date of the most recent invoice generated 

Last Raised Invoice =

VAR CurrentName = SELECTEDVALUE( 'Invoice Reminder Sheet 2'[Project Title])

RETURN

MAXX( FILTER( ALL( 'Invoice Reminder Sheet 2' ), 'Invoice Reminder Sheet 2'[Project Title] = CurrentName ),

'Invoice Reminder Sheet 2'[Date EDGE Ledger raised].[Date] )

is there a way to reference the above measure and use IF / DATEDIFF to show if more than 180 days has elapsed since the last invoice then a new one would be due? desired outcome if >180 days "Invoice Due x days ago", if <180 Days " X days till next invoice"

[BA_Pete · Accepted solution]

Hi @Anonymous ,

I guess it would be something like this:

_timeWindow =
VAR dDiff = DATEDIFF([yourMeasure], TODAY(), DAY)
RETURN
IF(
  dDiff > 180,
  "Invoice Due " & dDiff - 180 & " days ago",
  180 - dDiff & " days until next invoice"
)

Pete

[Anonymous]

@amitchandak @BA_Pete 

thank you for the help

worked exactly as i had hoped

thankyou!! 😀

[amitchandak]

@Anonymous , You can create a new measure like

datediff([Last Raised Invoice], today(), day)

or

if(datediff([Last Raised Invoice], today(), day)  > 180, "Invoice Due 180 days ago" , "Invoice Due below 180 days ago")

[Anonymous]

unfortunately i do not seem to be able to reference the 1st measure to create this new measure

the above works in a calculated column

may be this is what i need to do