Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need Help

Hi all,  I need help to write a measure comparing two date fields ('GL post date' and 'Original Invoice Date') in same table (Sales Fact). I had written following code to calculate date difference w...
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
3 years ago

Here's an alternate approach that you can use to calculate the date difference for each row in the 'Sales Fact' table:

 

AGE = 
VAR DateDiff = DATEDIFF('Sales Fact'[GL Post Date], 'Sales Fact'[Original Invoice Date], DAY)
RETURN SUMX(VALUES('Sales Fact'[Row]), DateDiff)