M Language If statement

[JajatiDev]

Hi,

Here is the DAX function I have written;

CRDD Month = IF('Orders'[customer_req_date]<= EOMONTH(TODAY(),0),"CRDD Current","CRDD Future")

Now, I am trying to write this in M Language but getting an error message.

if [customer_req_date] <= Date.IsInCurrentMonth(today(),0) then "CRDD Current" else "CRDD Future"

Error Message - The name today wasn't recognised. make sure it's spelt correctly.

My objective is to use the today function to identify the current month so that it remains dynamic and no intervention is required.

I am looking forward to the suggestions.

Thanks and Regards,

Jajati Dev

[tackytechtom · Accepted solution]

Hi @JajatiDev ,

The today() function does not work in Power Query. You can use the following instead:

Date.From(DateTime.LocalNow())

I got this from here.

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[JajatiDev]

Thanks for the response. Just figured out the same 😊