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

Hello Anonymous,

 

The formula you provided will return an average of the date difference between 'GL Post Date' and 'Original Invoice Date' for all the rows in the 'Sales Fact' table.