Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    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.

             

     

    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

Pragati11's avatar
Pragati11
Super User
6 years ago

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.

         

 

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

RaphaelM's avatar
RaphaelM
New Member
2 years ago

You were probably missing the " ( ) " at the end of the function.

If you call  DateTime.LocalNow , the output is going to be Function

If you call DateTime.LocalNow(), the output is going to be the real current date, for example, 2024-08-05.

  • JRD's avatar
    JRD
    Frequent Visitor
    2 months ago

    Thanks! That's what i was doing wrong