Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Incorrect DAX

Hi All,   Please see below data.     The column "Hire (Days)" is a calculated column created by the below DAX.   Hire Duration = DATEDIFF('Standing Scaffold Data'[On Hire Date],'Standing...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • FarhanAhmed's avatar
    FarhanAhmed
    6 years ago
    Hire Duration = DATEDIFF('Standing Scaffold Data'[On Hire Date],

IF(ISBLANK('Standing Scaffold Data'[Off Hire Date]),TODAY(),'Standing Scaffold Data'[Off Hire Date]),DAY)

     

    Try this.

FarhanAhmed's avatar
FarhanAhmed
Community Champion
6 years ago
Hire Duration = DATEDIFF('Standing Scaffold Data'[On Hire Date],

IF(ISBLANK('Standing Scaffold Data'[Off Hire Date]),TODAY(),'Standing Scaffold Data'[Off Hire Date]),DAY)

 

Try this.