Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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. Please advise.

 

 

 

 

3 REPLIES 3
kolturra
Helper IV
Helper IV

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
Not applicable

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

Hi,

 

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

 

Thanks,

K Raghavender Rao

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.