Forum Discussion
Data output
Anonymous , For new column, for any date you want to know last date of month
New column = eomonth([date], 0)
for today // you can use today in new column
New column = eomonth(today(), 0)
Anonymous , last day of each month is eomonth([Date],-1)
example
based on selected date
New Measure =
Var _max = maxx(allselected(Date) , Date[date])
return
calculate(sum(Table[value]), filter('Table', Table[date] =_max + time(23,30,0)))
with today
New Measure =
Var _max = today()
return
calculate(sum(Table[value]), filter('Table', Table[date] =_max + time(23,30,0)))
Hello sir,
I am trying to obtain the last day of the month that the data is in. For exmple on January, last day is 31 January. From the code, it gives the last day of the month before
Anonymous , For new column, for any date you want to know last date of month
New column = eomonth([date], 0)
for today // you can use today in new column
New column = eomonth(today(), 0)
works for me thankuu