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 moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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 )
User | Count |
---|---|
92 | |
88 | |
88 | |
79 | |
49 |
User | Count |
---|---|
156 | |
145 | |
105 | |
72 | |
55 |