Forum Discussion
DAX Query
Hi All, I have a data set similar to the below example. On Hire Date Off Hire Date Hire Duration (Days) 01/01/2020 10/01/2020 10 02/01/2020 10/01/2020 9 I want to creat...
Hi Anonymous ,
Hi Anonymous ,
You could follow the way of camargos88 to filter out in filter pane. Or you could use a IF function to implement it.
Please try this:
Measure = var diff = DATEDIFF(MAX('Table'[On Hire Date]),MAX('Table'[Off Hire Date]),DAY)+1 return IF(diff>=10, diff)
Hi Anonymous ,
You could follow the way of camargos88 to filter out in filter pane. Or you could use a IF function to implement it.
Please try this:
Measure =
var diff = DATEDIFF(MAX('Table'[On Hire Date]),MAX('Table'[Off Hire Date]),DAY)+1
return
IF(diff>=10, diff)