Forum Discussion

patricPBI's avatar
patricPBI
Icon for Helper I rankHelper I
6 years ago
Solved

DateDiff only works with measure and does not recognize columns

Hi,    As many others here, I would like to get the count difference of two dates.  I have one column called "closed dates" and another column called "Opened Dates"   When I try to do the "durat...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi @patricPBI ,

    You have got extra COMMA for MAX function. Remove them please as highlighted below:

    Pragati11_0-1600949634608.png

    Thanks,

    Pragati

patricPBI's avatar
patricPBI
Icon for Helper I rankHelper I
6 years ago

HI @Pragati11

patricPBI_0-1600946927278.png

It tells me that I cannot have just one argument for he MAX function

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi @patricPBI ,

You have got extra COMMA for MAX function. Remove them please as highlighted below:

Pragati11_0-1600949634608.png

Thanks,

Pragati

  • patricPBI's avatar
    patricPBI
    Icon for Helper I rankHelper I
    6 years ago

    thanks a lot Pragati11 

     

    That was indeed the mistake.