Forum Discussion
Comparing two dates using one calendar table and USERELATIONSHIP
Hi All, I want to compare two dates in a single measure to return a count of where delivery date > estimated delivery date within a period. I have two tables: 1) Fact Sales ([Order ID], ...
Rowwise comparison of columns is very expensive at runtime. I suggest you simply add a calculated column called "Late" and add a forumula somthing like this
=if(FactTable[Del Date] > FactTable[Est Del Date],"True")
You can then use this column in your measures.
Late orders = calculate(countrows(FactTable),FactTable[Late] = "True")
Thanks MattAllington. Really helpful.