topic Re: Subtracting two date columns in two different tables in DAX Commands and Tips

Subtracting two date columns in two different tables

Ronning — Fri, 01 Apr 2022 09:01:53 GMT

Hi, I have a problem with subtracting two date columns from different tables.

I have tried this. DATEDIFF( SUM( 'Table' [Column] ) , SUM( 'Table' [Column]) , DAY ).

But when i drag this measuer into a table it gives me this message.

" An unvalid numerical representation of a datevalue has occoured"

Could this be because thera are some future date in one column that dosent exist in the other ?

Thanks

Re: Subtracting two date columns in two different tables

tamerj1 — Fri, 01 Apr 2022 09:30:40 GMT

Hi Ronning
If there is a relationship between th etwo tables then if table1 is at the many side and table2 is at the one side and assuming that 'Table1'[Column] is the earlier date and 'Table2'[Column] is the later date then you can use

# Days = SUMX ( 'Table1', DATEDIFF ( 'Table1'[Column], RELATED ( 'Table2'[Column] ), DAY ) )

Re: Subtracting two date columns in two different tables

Ronning — Fri, 01 Apr 2022 09:46:25 GMT

I found out the problem... It was just to change SUM to MAX.