What will be daxt for this logice Last Invoice = max (Date) - today()

[mdaamirkhan]

Hi All,

What will be daxt for this logice  Last Invoice = max (Date) - today()

[StefanoGrimaldi]

adjust to this formula them: 

Last Invoice = 

DATEDIFF( LASTDATE(Date), today(), MONTH)

[mdaamirkhan]

Any update

[StefanoGrimaldi · Accepted solution]

Last Invoice = 

LASTDATE(Date)

this will give you the higher date on a column, if you the days since the last invoice would be 

Last Invoice = 

LASTDATE(Date) - today()

if this helped give some kudos and mark as solution for others to find.

[mdaamirkhan]

will it give in months as I need in months

[StefanoGrimaldi]

adjust to this formula them: 

Last Invoice = 

DATEDIFF( ASTDATE(Date), today(), MONTH)

[amitchandak]

@mdaamirkhan , Please try a measure 

datediff(maxx(allselected('Date'),'Date'[Date]), Today(), day)

[mdaamirkhan]

not working it return 0 value

[Ashish_Mathur]

Hi,

Share some data and show the expected result.