Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Days since 1900 Formula

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.

2 ACCEPTED SOLUTIONS
az38
Community Champion
Community Champion

Syndicated - Outbound

Hi @Anonymous 

try a dax column

Column = VALUE(TODAY())

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

v-deddai1-msft
Community Support
Community Support

Syndicated - Outbound

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

 

View solution in original post

2 REPLIES 2
v-deddai1-msft
Community Support
Community Support

Syndicated - Outbound

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
Community Champion
Community Champion

Syndicated - Outbound

Hi @Anonymous 

try a dax column

Column = VALUE(TODAY())

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)