Maximum Date

[Anonymous]

Dear Friends i need a small help

How to write a DAX

Start date : 7/10/2019 (MMDDYY)

End Date : 8/6/2019 (MMDDYY)

i need a minimum Date of end date output : 8/1/2019

i want to calculate difference dates b/W 8/6/2019  minmum of end date i.e 8/1/2019 

DATEDIFF(minmum of end date i.e 8/1/2019, end date i.e 8/6/2019, day)

Thanks

Godasu

[v-xicai · Accepted solution]

Hi @Anonymous ,

You may try to create measures like DAX below.

DateDiff= DAY(LASTDATE(Table1[Date]))-1

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xicai]

Hi @Anonymous  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[saykasku · Accepted solution]

Hi,

I think You need this:

DayDiff = 
var _maxDate = MAX(time[dates])
RETURN
DATEDIFF(
    DATE(YEAR(_maxDate);MONTH(_maxDate);1);
    MAX(time[dates]);
    DAY
)

[v-xicai · Accepted solution]

Hi @Anonymous ,

You may try to create measures like DAX below.

DateDiff= DAY(LASTDATE(Table1[Date]))-1

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous ,

The requirement is not clear.

Can you upload sampledata,pbix and output expected to Google/OneDrive and share the link here to find the right solution.

Cheers

CheenuSing