- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous
try a dax column
Column = VALUE(TODAY())
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous
try a dax column
Column = VALUE(TODAY())

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Join our Community Sticker Challenge 2025
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Subject | Author | Posted | |
---|---|---|---|
05-29-2024 01:17 AM | |||
12-13-2023 09:26 AM | |||
03-21-2024 02:55 PM | |||
09-09-2024 05:05 PM | |||
05-09-2024 04:49 AM |
User | Count |
---|---|
92 | |
65 | |
62 | |
43 | |
40 |