Learning PowerBI: Why do functions return "function" in a table, instead of actual "value"?

Hi Anonymous ,

I tried both scenarios in Power BI at my end.

1. Created a custome column "test" using DateTime.LocalNow(). This gave me the current value in date-time format.
2. Created a custom column "test1" usingDateTime.Date(DateTime.LocalNow()). This gave me the current value indate format.
3. 

Just wanted to check if you can paste screenshot of the FUNCTION message which you are getting while using DateTime.LocalNow() as I don't get any such message at my end?

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati