Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |