Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
I've been striking out on what I believe is something simple. I have two date fields in my table. They are both formatted as a date. I want to create a column that shows the #days difference between the two days. I checked other solutions and many of them suggested using DateDiff but I havent been able to get it to work.
Table: Main Table
Field1: Date Completed
Field 2: Date Received
I want to be able to get the # days between Field 2-Field 1.
Solved! Go to Solution.
Create a new column and then use datediff
Column 1 = DATEDIFF('main table'[Date Completed],'main table'[Date Received],Day)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 86 | |
| 85 | |
| 68 | |
| 64 |