March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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 )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
91 | |
86 | |
77 | |
49 |
User | Count |
---|---|
164 | |
149 | |
101 | |
73 | |
56 |