Forum Discussion
Solved
M Language If statement
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 b...
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/
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/
Thanks for the response. Just figured out the same 😊
