Forum Discussion
Data output
Hi everyone,
Can anyone help me code, im trying to get my value from the last day of each month at 1130 PM. Im unsure how to code to find the last day of each month
Thank you.
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)
4 Replies
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)))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)