Data output

[Anonymous]

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.

[amitchandak]

@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]

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

[amitchandak · Accepted solution]

@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]

works for me thankuu