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...
Hi Anonymous, you need to use the function USERELATIONSHIP, please check here how to use it: https://learn.microsoft.com/en-us/dax/userelationship-function-dax
If my answer fullfil your question, please mark it as a solution
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?
