Days since 1900 Formula

[Anonymous]

I know that in Excel there is a function that turns a date into the whole number equivalent of days since 1900. Is there a way to do this in Power BI? I appreciate any help.

[az38 · Accepted solution]

Hi @Anonymous 

try a dax column

Column = VALUE(TODAY())

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

In addition to az38's reply. VALUE(Date) is computing date from 12/30/1899. So you should use VALUE(Date)+2 .

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[az38 · Accepted solution]

Hi @Anonymous 

try a dax column

Column = VALUE(TODAY())