Forum Discussion
Measure using a non active relation
Hello all From a great DB where I can find orders, sells, purchasing and other documents, I have many dates collumns (such as document creaton date and deliery date). I have this big DB linked to...
Like this
Total sales =
CALCULATE(
SUXMX(table, table[EUR] )
, USERELATIONSHIP( table[delivery date], calendar[date] )
)So far does not retrieve any error, but does not calculate it. I want to add every order to be delivered within EOM of each Month, Year
In other words, I want to reply the question "How much do we expect to invoice within the ending of X month"
Any ideas?