Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Maximum Date

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

Tips and Tricks

v-xicai
7 years ago
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.

Hi,

I think You need this:

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

4 Replies

Anonymous
Not applicable
7 years ago
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
v-xicai
Community Support
7 years ago
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.

Resolver I

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
Community Support
7 years ago
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

Related content