Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have to create the datediff between the 'project from date' and 'today' in days.
However I am not able to specify 1st date parameter column.
Is there a way I can calculate difference between 2 dates?
Solved! Go to Solution.
Hi @chaitanyajiwani ,
There are two solutions:
1.Please create a new column:
Column = DATEDIFF('Table'[project from date],TODAY(),DAY)
2.Please create a new measure:
gap = DATEDIFF(MAX('Table'[project from date]),TODAY(),DAY)
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @chaitanyajiwani ,
Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.
Hi @chaitanyajiwani ,
There are two solutions:
1.Please create a new column:
Column = DATEDIFF('Table'[project from date],TODAY(),DAY)
2.Please create a new measure:
gap = DATEDIFF(MAX('Table'[project from date]),TODAY(),DAY)
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@chaitanyajiwani ,Try this
DATEDIFF(TableName[Proj Start Date Column],Today(),DAY)
I tried that, but I am not able to add the first date parameter is i.e. 'Project From Date' column.
Hi @chaitanyajiwani
Please try
DATEDIFF ( SELECTEDVALUE ( TableName[Proj Start Date Column] ), Today ( ), DAY )
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
85 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
97 | |
71 | |
67 |