Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

EOMONTH function in M Language

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....
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
kolturra
Helper IV
8 years ago

Hi,

 

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

 

Thanks,

K Raghavender Rao