Forum Discussion
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 todays date."
- DD_Current =VAR MN_Date = MIN('Date'[Date])VAR Result = DATE(YEAR(TODAY()),MONTH(MN_Date),DAY(MN_Date))RETURNResultI hope it is helpful for you.
6 Replies
Can you explain with some data snap shot for more understanding.
"I have this
i want if i select 15 aug then measure calculaion give me return value of 15 aug"
You want current year date right.
yes, if i select 20 aug on my date slicer then measure give me exact thaat value not todays date 15-12-22
- DD_Current =VAR MN_Date = MIN('Date'[Date])VAR Result = DATE(YEAR(TODAY()),MONTH(MN_Date),DAY(MN_Date))RETURNResultI hope it is helpful for you.
Thanks sir.
