Trying to Get DATEDIFF to work but it's not.

[Anonymous]

hi all, 

I'm trying to get this formula to work 

DATEDIFF(ProviderAccountMaster[CreatedDT],RELATED(AccountMaster[CreatedDT], DAY)

how ever it is not. i'm getting the Error (Too many arguments were passed to the RELATED function. The maximum argument count for the function is 1.) 

And i also get the related tables error (The column 'AccountMaster[CreatedDT]' either doesn't exist or doesn't have a relationship to any table available in the current context.) but i have them related. 

I have them related so i'm a bit confused. 

tables i'm using for DATEDIFF funtion

[MFelix]

Hi @Anonymous ,

Believe that your issue is related with parentenses. Try to modify your calculation to the following:

DATEDIFF (
    ProviderAccountMaster[CreatedDT],
    RELATED ( AccountMaster[CreatedDT] ),
    DAY
)

Regards,

MFelix

[Anonymous]

done that but still getting this error. 

The column 'accountMaster[CreatedDT]' either doesn't exist or doesn't have a relationship to any table available in the current context.

NewAccounts = DATEDIFF(MAX(ProviderAccountMaster[CreatedDT]), RELATED(accountMaster[CreatedDT]), DAY)

any sugguestions with the below relationships? 

[MFelix]

Hi @Anonymous ,

Can you share a sample file, if the data is sensitive can you share it trough private message or with mockup data?

Regards,

MFelix