topic Re: Date column formula in Custom Visuals Development Discussion

Date column formula

Anonymous — Fri, 13 Sep 2019 09:19:53 GMT

I was trying to get date of joining in the formulated way to prepare the attrition report but i was getting error while customize the column with below formula.

= { #"Date of Joining" ..Number.From(Date.From(DateTime.LocalNow()))}

i was doing this report by taking help from youtube videos.

Sam

Re: Date column formula

Nathaniel_C — Sat, 14 Sep 2019 18:14:34 GMT

Hi @Anonymous ,

What are you trying to do? Are you trying to get the immediate time in a calculated column? Then NOW() should be sufficient. Please give us more information.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Re: Date column formula

Nathaniel_C — Sat, 14 Sep 2019 18:22:00 GMT

Hi @Anonymous ,

Or if you are working in Power Query the formula Table.AddColumn(#"Changed Type1", "Custom", each Number.From(Date.From(DateTime.LocalNow()))) that you posted does work. I then get a number back.

See picture. Perhaps you are putting the code somewhere other than Power Query?

Give us more details...

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Re: Date column formula

Anonymous — Thu, 10 Oct 2019 10:09:24 GMT

Thank you for your reply.

could you please tell me why i am not getting those numbers..

Regards

Sam