Forum Discussion

Anonymous's avatar
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 calc...
Tips and Tricks
  • v-xicai's avatar
    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.

  • saykasku's avatar
    saykasku
    7 years ago

    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's avatar
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