Forum Discussion

SachinNamdeo-20's avatar
SachinNamdeo-20
Helper II
3 years ago
Solved

For current date

" How can i get current date dynamically ,today function only give me last date of my data table  but i want to calculate date dynamically if i select any date of calender it gives me that date not t...
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago
    DD_Current =

     VAR MN_Date = MIN('Date'[Date])

     VAR Result = DATE(YEAR(TODAY()),MONTH(MN_Date),DAY(MN_Date))

     RETURN
     Result

     

    I hope it is helpful for you.
Mahesh0016's avatar
Mahesh0016
Super User
3 years ago
DD_Current =

 VAR MN_Date = MIN('Date'[Date])

 VAR Result = DATE(YEAR(TODAY()),MONTH(MN_Date),DAY(MN_Date))

 RETURN
 Result

 

I hope it is helpful for you.