Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

YTD Issue

Order Entry = CALCULATE(SUM(Central[OrderConfirmationValue]), Central[Document Type]="Order Entry")
Net Sales = CALCULATE(SUM(Central[OrderConfirmationValue]), Central[Document Type]="Net Sales")
 
Order In Hand = [Order In Hand] - [Net Sales]
 
My requirement is YTD 
 
                                   Jan    Feb    Mar
Order Entry                 100
Net Sales                     10
Order In Hand             90
 
How can do this using matrix