Forum Discussion
Learning PowerBI: Why do functions return "function" in a table, instead of actual "value"?
Ok... so I'm trying to learn the basics of Power BI, and I have a few points that are just down right confusing... This isn't specific to DateTime, but I'm using it as a sample function... If...
Hi Anonymous ,
I tried both scenarios in Power BI at my end.
- Created a custome column "test" using DateTime.LocalNow(). This gave me the current value in date-time format.
- Created a custom column "test1" usingDateTime.Date(DateTime.LocalNow()). This gave me the current value indate format.
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
Anonymous I don't know why you are getting function, DateTime.LocalNow() should return date/time (date with timestamp)
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!