EOMONTH function in M Language

[Anonymous]

is there any M language for EOMONTH function to use in PBI Query Editor.

I already tried Date.EndOfMonth as link:

https://msdn.microsoft.com/query-bi/m/date-endofmonth

But did not worked. Please advise.

 

[kolturra]

Hi,

Can you please give example like what you are trying to achieve or Will DAX solve your problem?

EMonth = EOMONTH(NOW(),-1) 

Thanks,

K Raghavender Rao

[Anonymous]

Hi Rao,

In DAX using measured Column it is working:

EOMONTH = EOMONTH(table[date], -1) but data refresh get slow if I use DAX.

But I need to use this function in Query Editor using Conditional/Custom  Column to use EOMONTH in IF formula.

Like excel formula: =IF(table[Date]<=EOMONTH(TODAY(),-1),"PRIOR MONTHS",DUE)

Thanks,

Salem

[kolturra]

Hi,

I am working on this query, since i am in learning stage of M QUERY, give me sometime.

Thanks,

K Raghavender Rao